I am trying to create a chart using data from two separate worksheets but it
will only allow me to use the information from one.

Here is one way:
I made a chart from data in A10:B20 on sheet1 (A was the x-category data)
I copied some cells from Sheet2, right clicked in chart area of chart and
used Paste

After the copy, I could have left clicked the chart and used Edit | Paste
Special to specify more about the data I want to paste.

Try it and come back with more questions.

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"cdptuesdays" wrote in message
...
I am trying to create a chart using data from two separate worksheets but
it
will only allow me to use the information from one.

I've posted some information about this topic:

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

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


"cdptuesdays" wrote in message
...
I am trying to create a chart using data from two separate worksheets but
it
will only allow me to use the information from one.