ploting one cell from 10 worksheets into one chart

[alexoxela]

i am trying to figure out a way to plot one cell, lets say c-1 from 10
-30 worksheets, in one workbook; on one chart. Each worksheet is a date
and each c-1 value is just a number.

any help would help

thanks

alex n.

(e-mail address removed)



------------------------------------------------




------------------------------------------------

 

[Tushar Mehta]

You can plot each data point as a separate series. If you want them to
be a single series, you have to get them on a single worksheet first.

--
Regards,

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