chart question

  • Thread starter Thread starter guideme
  • Start date Start date
G

guideme

I have 2 sheets: (more as time comes).
Jan 05 - sheet 1
- sales problems
- support problems
- operations problems
- finance problems


Feb 05 - sheet 2
- sales problems
- support problems
- operations problems
- finance problems

I need to graph these 2 sheets with same categories but different total
percentages of the month using the chart bars to show the changes for
the same category (side by side) in a year...

confused yet? :)
can you give me a hint on how to do this and the formula if there are
any.
 
Well, if it were me, I'd probably put the data that you are graphing on the
same worksheet.
Jan05 Data Feb05 Data
Sales Problems .5 .4
Support Problems .3 .2
Operations Problems .1 .3
Finance Problems .1 .1
 
The secret to using data from multiple sheets is in the Source Data for the
chart. Right-click the chart, Source Data, and go to the Series tab.

Also, you might want to keep your data, since it's related data, on one
sheet. Take a look at http://www.smokeylake.com/excel/excel_truths.htm.
Read "Data across multiple sheets."
 
Back
Top