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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top