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" <jim@deteste_vraiment.le.spam> wrote in message
news:040520052154461729%jim@deteste_vraiment.le.spam...
Or alternatively, is there a better way to manage my data?

Jim

In article <u8tucaYUFHA.3840@tk2msftngp13.phx.gbl>, RagDyeR
<ragdyer@cutoutmsn.com> 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