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
9..U20 in the Range area in the Ranges window for the chart.
Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com
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
9..U20 in the Range area in the Ranges window for the chart.Neil
Cat Paintings At Carol Wilson Gallery
http://www.carolwilsongallery.com