Multi-sheet bar chart data problems
Hi folks,
I have a multi-sheet workbook. Each page has a sell containing a total - let's call it "D2" again... :o) I want to take data from cell "D2" on each sheet and make a "clustered column" chart. I also want each column to take the name of each sheet, thus: __ __ __ __ __ __ __ __ __ |______|______|______| sheet1 sheet2 sheet3 etc. Is this possible? I have tried using the Chart Wizard but, when I select cell D2 across all sheets... Data range: ='sheet1:sheet4'!$D$2 ....it returns an error: "Reference is not valid". Any advice? TIA... Jim |
Or alternatively, is there a better way to manage my data?
Jim |
Might I suggest that since a day has gone by without a suggestion, you might
try a specialized group. I personally don't know squat about graphing in XL, but the people who frequent this group should know a whole bunch: microsoft.public.excel.charting -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Jim M" wrote in message am... Or alternatively, is there a better way to manage my data? Jim |
In article , RagDyeR
wrote: Might I suggest that since a day has gone by without a suggestion, you might try a specialized group. I personally don't know squat about graphing in XL, but the people who frequent this group should know a whole bunch: microsoft.public.excel.charting I appreciate your honesty! ;o) I'll try that, thanks. Jim |
All times are GMT +1. The time now is 07:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com