Hi,
I am trying to create a chart which uses data from two
sheets and i can do fine. However when i enter the data
range from one of the sheets different to the range on
the other sheet, the error message "Reference Is Not
Valid" appears. How can i get two differnet sheets to be
put into a chart without having the data in the same
cells.
Thanks a lot,
Chris Grant

Chris -

See this page, Charting Data From Different Sheets:

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

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

Chris Grant wrote:

> Hi,
> I am trying to create a chart which uses data from two
> sheets and i can do fine. However when i enter the data
> range from one of the sheets different to the range on
> the other sheet, the error message "Reference Is Not
> Valid" appears. How can i get two differnet sheets to be
> put into a chart without having the data in the same
> cells.
> Thanks a lot,
> Chris Grant