View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Create a Chart w/data from multiple worksheets

http://peltiertech.com/Excel/ChartsH...iffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Tia" wrote in message
...
I have an excel file that has the following worksheets.

Jan 4
Feb 5
March 6
June 7
July 6

They each have data in the cell G15. I need the data from each of those
cells plotted on the same chart. We've been using Lotus and it was super
simple. I'm at a loss how to do the same thing in Excel.

Thanks to anyone who can answer this question!!