Logarithmic X Axis in PivotChart

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

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Edward Ramsden wrote:

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

On Wed, 22 Oct 2003 11:25:06 -0400, Jon Peltier
wrote:

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.

--
Dave
dvt at psu dot edu

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 :-)

-----Original Message-----
On Wed, 22 Oct 2003 11:25:06 -0400, Jon Peltier
wrote:

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.

--
Dave
dvt at psu dot edu
.

On Thu, 23 Oct 2003 06:04:21 -0700, Edward Ramsden
wrote:
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

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, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Edward Ramsden wrote:
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 :-)


-----Original Message-----
On Wed, 22 Oct 2003 11:25:06 -0400, Jon Peltier
wrote:


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.

--
Dave
dvt at psu dot edu
.

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

dvt wrote:

On Wed, 22 Oct 2003 11:25:06 -0400, Jon Peltier
wrote:

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.