Pivot Chart Legend Manipulation

Question

In previous versions of Excel (<=2003), upon creating a pivot table

and accompanying pivot chart, to obtain a contour map, for example, one could manipulate

the number of colors/contours (major/minor units) via double clicking

in the legend on the Pivot Chart. One was then presented with a dialog/

option window that was somewhat similiar to the functionality of

manipulating standard chart axes, i.e. one could manipulate/change

major and minor units to achieve the desired number of contours.

In Excel 2010, I am unable to find the/a way to acheive the same end.

I have the contour chart (based on the pivot table). It has a number

of ranges in the legend leading to a given number of contours. I would

like to cut the number of contours in half. Example: it now has 10

steps between 200 and 400. I would like to have 5 steps between 200

and 400.

Can anyone provide any insight?

Hopefully my description here makes some sense.

Thank you in advance for your assistance.

Answer 1

Excel 2010 PivotTable, PivotChart

Edit contour band width of 3D plot.

http://c3017412.r12.cf0.rackcdn.com/01_06_11.xlsx

If you get *.zip, don't unzip, just rename *.xlsx

1.7MB

Answer 2

Click on the chart.

Activate the Layout tab of the ribbon.

Select Vertical (value) axis from the Chart Elements dropdown in the Current Selection group.

Click Format Selection.

You can set the scale there.

Answer 3

Fabulous... thank you BOTH so much. I KNEW it was hiding in there somewhere. Still getting used to the new arrangement of features...