Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
In previous versions of Excel (<=2003), upon creating a pivot table
and 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicating Pivot Chart / Changing Pivot Chart data range | Excel Discussion (Misc queries) | |||
chart legend changing when I use Select data | Charts and Charting in Excel | |||
change the text in the legend of a chart w/o changing pivot text | Charts and Charting in Excel | |||
Pivot Chart, changing the range of data weekly | Charts and Charting in Excel | |||
Pivot Chart Legend | Excel Discussion (Misc queries) |