How do I create a chart in Excel using data from two worksheets

[cdptuesdays]

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.

 

[Bernard Liengme]

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

 

[Jon Peltier]

I've posted some information about this topic:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

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