Can't convert Pivot Chart to Regular One

**Bob@Sun** · 10-31-2010, 04:12 AM

Hello,

Can anybody help me with transferring the attached Pivot Chart to a regular Chart please?

Thanks in advance!

**teylyn** · 10-31-2010, 04:45 AM

Hi Bob,

first, copy the data table, i.e. A5:C23 and paste somewhere else. Then build the chart off that data. It will not be a pivot chart, but a regular chart.

**Bob@Sun** · 10-31-2010, 07:51 AM

Yes, but how can I put the Country names and the months in the Axis of the regular chart?
That is where I am facing difficulties.

**teylyn** · 10-31-2010, 05:15 PM

Question: Why do you want to use a regular chart instead of the pivot chart? What does it offer that the pivot chart does not?

Attached see a copy of your PT data and a regular chart on Sheet3. Look at the data source for the chart, especially at the X axis labels. It's just a selection of both columns A and B.

cheers