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 150Is this possible? Thanks!

✔ 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 bothI 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.

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

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!

Are the dates in the date column excel date values or text values?

They are in date values.

Not sure I can get the stacking part in I can get

Y axis = minutes

X axis = Code

Series = date OR engineer but not bothI 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.

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.

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?

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

Ask Your Question

Weekly Poll

Do you think Jony Ive could make a big impact on Airbnb?

Discuss in The Lounge

Poll History