Data from more than one worksheet

N

Nhmiller

I see how to do a chart in Excel for one of my years, but can find nothing in
the Help section for connecting years. Cannot find how to enter a statement for
the range of data to plot on a chart when the data is on several pages in one
worksheet file. I have a separate worksheet for each year and want to plot one
chart that connects all the years together. Horizontal axis will be the months,
Vertical axis will be the minimum to maximum range of values. There are 21
separate pages of worksheets from 1984 to 2004. Did this easily in Lotus 123 by
just entering A:D9..U:D20 in the Range area in the Ranges window for the chart.

Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Data from more than one worksheet 1
Employee Schedule not plotting properly - chart type / data series not correct 0
Offset Horizontal axis data 1
Axis Options - Minimum and Maximum Values 2
Data disappears when I edit the chart. 1
Abstracting Error Bar Data From Charts 3
Value Y axis - Not to start from zero 2
data labels in charts 1

Top