ploting one cell from 10 worksheets into one chart

A

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.

[email protected]



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




------------------------------------------------
 
T

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
 
Top