Logarithmic X Axis in PivotChart

[Edward Ramsden]

I am trying to display a PivotChart with a logarithmic
scale on the X axis. Normally I would create an X/Y chart
to do this, but I can't do this with a PivotChart, and the
line chart doesn't allow the X axis to be set to
logarithmic. Is there any way I can get Excel to display
my X axis using a logarithmic scale?

Thanks

Edward

 

[Jon Peltier]

Edward -

I'm stuck on Excel 97 here at work, so I can't check whether pivot
charts even offer the option of an XY Scatter chart. In a non-pivot
chart, you'd make an XY Scatter chart, which has a value X axis, not a
category X axis, then you double click the axis, select the Scale tab,
and check the Logarithmic Scale box while setting the other scale
parameters.

If you can't get this type with a pivot chart, you can make a regular
chart from the pivot table. Select an empty cell and start the chart
wizard. In step 1, select a Scatter chart with the appropriate styles.
In step 2, select the Series tab, click Add, then range by range,
select the range that contains the X values, Y values, and series name.
Reclick Add to add more series. When you're done, finish the wizard,
then fix your axis.

- Jon

 

[dvt]

Edward -

I'm stuck on Excel 97 here at work, so I can't check whether pivot
charts even offer the option of an XY Scatter chart.

I have Excel XP. It doesn't allow XY scatter, bubble, or stock chart
types in the pivot chart.

 

[Edward Ramsden]

Thanks for your responses.

The PivotChart is limited in the charts it will create, and
X/Y is not one of the ones it offers.

I've found that if you select the cells in a PivotTable and
try to manually create a chart for the range, Excel
creates a PivotChart every time. If only it gave you the
choice :-(

I've managed to get around this by writing a macro to read
the cells in the table, copy the contents to another sheet
and then chart those. By running this in the refresh event
for the PivotTable sheet I can get all the functionality of
a PivotChart without the restrictions

 

[dvt]

I've managed to get around this by writing a macro to read
the cells in the table, copy the contents to another sheet
and then chart those. By running this in the refresh event
for the PivotTable sheet I can get all the functionality of
a PivotChart without the restrictions

Nice solution.

Dave
dvt at psu dot edu

 

[Jon Peltier]

Edward -

No macro required. I've decided that Pivot Charts haven't lived up to
the hoopla, so I've learned to make regular charts from Pivot Tables.
Select a blank cell outside of the pivot table and start the Chart
Wizard. In Step 1, choose your chart type. In Step 2, click on the
Series tab, then click Add. Select the ranges that contain the series
Name, X Values (or Category Labels), and Y Values. Click Add and repeat
for additional series. Finish the Wizard as usual.

- Jon

 

[Jon Peltier]

Nor will it allow combination charts. A neat idea that needs further
development.

- Jon