software

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

quot;cdptuesdaysquot; gt; wrote in message
...
gt;I am trying to create a chart using data from two separate worksheets but
gt;it
gt; will only allow me to use the information from one.
I've posted some information about this topic:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;cdptuesdaysquot; gt; wrote in message
...
gt;I am trying to create a chart using data from two separate worksheets but
gt;it
gt; will only allow me to use the information from one.