2 charts on 1 worksheet

[Guest]

I have 2 data sources that I want to make a chart for. This is for a company survey I need a chart for Performance and 1 for Importance. There are 12 questions that I need to make charts for. I really want to keep a Performance chart and an Importance chart for each question on the same worksheet. Any suggestions?

 

[Tushar Mehta]

I must be missing something...

Select the performance data and use the Chart Wizard to create a chart.

Then, select the importance data and use the Chart Wizard to create a
chart.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

What I am trying to say is, that I have already made a pie chart for the performance (Strongly Agree, Agree, Ect.) that shows the pertancage of stongly agree, agree, ect. for each question. Now I want to do the same for Importance (Import, Very Import, Ect.) , but I want both pie charts on one worksheet. Is there any way of doing this, so I don't have 24 chart tabs in one workbook, instead I only want to have 12?

 

[Jon Peltier]

When you're making the chart, on the last step of the chart wizard, for
location, do not choose As New Sheet, choose As Object In, and pick the
worksheet to embed it in.

- Jon

 

[Jon Peltier]

When you're making the chart, on the last step of the chart wizard, for
location, do not choose As New Sheet, choose As Object In, and pick the
worksheet to embed it in.

- Jon