Solved Excel Chart Help

July 25, 2011 at 15:38:34
Specs: Windows XP
I am trying to chart multiple things on one chart. I have a date, a person, a code and # of minutes. So I'm trying to chart by date, by person the # of minutes per code. And I need the minutes to sum for each because there may be more than one code per date. Here is a small section of the spreadsheet.

Date Engineer Code Time (Minutes)
7/18/11 Shannon 5 360
7/18/11 Shannon 7 60
7/18/11 Shannon 1 120
7/21/11 Shannon 1 255
7/22/11 Shannon 5 180
7/22/11 Shannon 1 165
7/22/11 Shannon 7 165
7/18/11 Rene 2 210
7/18/11 Rene 1 60
7/18/11 Rene 7 120
7/18/11 Rene 1 60
7/18/11 Rene 3 120
7/18/11 Rene 5 30
7/22/11 Rene 7 90
7/22/11 Rene 1 75
7/22/11 Rene 3 60
7/22/11 Rene 2 30
7/18/11 Mike 1 120
7/18/11 Mike 7 90
7/18/11 Mike 3 120
7/20/11 Mike 6 30
7/20/11 Mike 4 180
7/20/11 Mike 6 45
7/21/11 Mike 3 150

Is this possible? Thanks!


See More: Excel Chart Help

Report •


✔ Best Answer
July 26, 2011 at 10:15:02
Not sure I can get the stacking part in

I can get

Y axis = minutes
X axis = Code
Series = date OR engineer but not both

I would need to tweek the spreadsheet a bit more if you are still interested, but I think excel lacks one more dimension for doing the type of graph you are envisioning.

So one graph can be total number of minutes spent on each code grouped by date, and the other can be the total number minutes spent on each code by engineer.

hrrmmm I suppose one could group the date and the code as an identifier for the X axis. Then you would get Code+ Date accross the X axis, things would then be grouped by engineer, and then have minutes on the X, and you can make an engineer called all that would be your total minutes. Still not what you were asking for exactly, but might work for you. Let us know.



#1
July 25, 2011 at 17:58:23
What kind of chart are you going after?

I am personally only really familiar with scatter charts, but I can tinker with the rest and see what I can figure out

What did you want for an X axis
What did you want for a Y axis


Report •

#2
July 26, 2011 at 08:27:17
I was hoping for a stacking bar chart with the x axis = code and y axis = minutes and side by side columns by date which would be stacking to include each of engineers. Thanks!

Report •

#3
July 26, 2011 at 09:44:38
Are the dates in the date column excel date values or text values?

Report •

Related Solutions

#4
July 26, 2011 at 10:09:42
They are in date values.

Report •

#5
July 26, 2011 at 10:15:02
✔ Best Answer
Not sure I can get the stacking part in

I can get

Y axis = minutes
X axis = Code
Series = date OR engineer but not both

I would need to tweek the spreadsheet a bit more if you are still interested, but I think excel lacks one more dimension for doing the type of graph you are envisioning.

So one graph can be total number of minutes spent on each code grouped by date, and the other can be the total number minutes spent on each code by engineer.

hrrmmm I suppose one could group the date and the code as an identifier for the X axis. Then you would get Code+ Date accross the X axis, things would then be grouped by engineer, and then have minutes on the X, and you can make an engineer called all that would be your total minutes. Still not what you were asking for exactly, but might work for you. Let us know.


Report •

#6
July 26, 2011 at 11:32:46
Ok, thank you so much for your help. I was hoping there was a way to do this, but apparently there is not. I will just make the graph without the date portion. I really appreciate all of your help with this.

Report •

#7
July 26, 2011 at 11:48:46
Is it true that the same engineer will work on the same code on the same date and be separate entries in your data?

IE Renee working on Code 1 for 60 minutes twice on July 18th from your sample data.

or was it supposed to be a single entry of 120 for Renee on July18th?


Report •

#8
July 26, 2011 at 12:00:01
DOH missed that last reply. I did get my hrrmmm section to work where the X axis was date and code, and Y was the minutes, and there was a bar for the total and for each engineer.

The only thing I did not do and it was a step away was total for multiple entries by same engineer on same date on same code.

If you want any further help with this send me a message, or check back regularly to see if someone else comments


Report •


Ask Question