Area chart

[Jeff]

I have a really studpid question. How do you create an
area chart when you have different data points on
seperate sheets. For example, I have four worksheets
(June, July, August, September) and want to pick one
number from each sheet for the chart data. I am new to
excel and have no clue. Thanks for any help.

 

[Tushar Mehta]

The range that constitues the x- or y- values for a single series must
come from a single worksheet. So, create a range on a single sheet
with the data from the separate sheets. Depending on what the data
represent and how they are updated, use of a formula might simplify
maintenance.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jeff]

Tushar,

Thank you for the response. Now I see what I was doing
wrong.

Jeff

 

[Tushar Mehta]

You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Tushar,

Thank you for the response. Now I see what I was doing
wrong.

Jeff

{snip}