Area chart

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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.
 
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
 
Back
Top