If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Logarithmic X Axis in PivotChart
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 |
#3
|
|||
|
|||
Logarithmic X Axis in PivotChart
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 |
#4
|
|||
|
|||
Logarithmic X Axis in PivotChart
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 . |
#5
|
|||
|
|||
Logarithmic X Axis in PivotChart
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 |
#6
|
|||
|
|||
Logarithmic X Axis in PivotChart
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 . |
#7
|
|||
|
|||
Logarithmic X Axis in PivotChart
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. |
Thread Tools | |
Display Modes | |
|
|