Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
How do you set the contour plot z-axis legend scale in 2007? In 2003 I could
double click on the legend and then select the bottom point, range between points and top point of the z-axis scale. Also, is there a way to get rid of the 3-D look of 2007 and go back to the 2003 countour plot look with flat/uniform colors for a given range of data? |
#2
![]() |
|||
|
|||
![]()
To set the contour plot z-axis legend scale in Excel 2007, you can follow these steps:
As for getting rid of the 3-D look of the contour plot in Excel 2007, you can follow these steps:
This will change the contour plot to a flat surface with uniform colors for a given range of data, similar to the 2003 contour plot look.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
How do you set the contour plot z-axis legend scale in 2007?
Activate the Layout or Format tab, and choose the Vertical (Value) Axis from the dropdown in the top left of the ribbon. (Yes, it's there even though it's a flat contour chart). Press CTRL+1 (numeral one) to open the Format Axis dialog, and adjust the scale here. is there a way to get rid of the 3-D look of 2007? Don't you hate that? It's absolutely miserable. This is a royal pain to fix. You have to do this for each series: Select the corresponding legend entry for the series, and press CTRL+1 to format it. Select 3D Format from the items on the left edge of the dialog, then under Surface Material, choose Flat (third one in the Special Effect row). Ironic that Flat is a special effect. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Randy" wrote in message ... How do you set the contour plot z-axis legend scale in 2007? In 2003 I could double click on the legend and then select the bottom point, range between points and top point of the z-axis scale. Also, is there a way to get rid of the 3-D look of 2007 and go back to the 2003 countour plot look with flat/uniform colors for a given range of data? |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Thanks Jon!
Who would have guessed that the Y-axis is elevation on a contour plot?! I also found that if I saved the file in 2003 format the 3D shading went away. Still used a bad color selection for depicting the data but it is at least a quick way to get them all to change at once. Randy "Jon Peltier" wrote: How do you set the contour plot z-axis legend scale in 2007? Activate the Layout or Format tab, and choose the Vertical (Value) Axis from the dropdown in the top left of the ribbon. (Yes, it's there even though it's a flat contour chart). Press CTRL+1 (numeral one) to open the Format Axis dialog, and adjust the scale here. is there a way to get rid of the 3-D look of 2007? Don't you hate that? It's absolutely miserable. This is a royal pain to fix. You have to do this for each series: Select the corresponding legend entry for the series, and press CTRL+1 to format it. Select 3D Format from the items on the left edge of the dialog, then under Surface Material, choose Flat (third one in the Special Effect row). Ironic that Flat is a special effect. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Randy" wrote in message ... How do you set the contour plot z-axis legend scale in 2007? In 2003 I could double click on the legend and then select the bottom point, range between points and top point of the z-axis scale. Also, is there a way to get rid of the 3-D look of 2007 and go back to the 2003 countour plot look with flat/uniform colors for a given range of data? |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
The 97-2003 file format is a good find. You can also turn the 3-D effect for
a chart all at once through automation by running in Visual Basic: ActiveChart.ChartGroups(1).Has3dShading = False -- Thanks, Christopher This posting is provided "AS IS" with no warranties, and confers no rights. "Randy" wrote: Thanks Jon! Who would have guessed that the Y-axis is elevation on a contour plot?! I also found that if I saved the file in 2003 format the 3D shading went away. Still used a bad color selection for depicting the data but it is at least a quick way to get them all to change at once. Randy "Jon Peltier" wrote: How do you set the contour plot z-axis legend scale in 2007? Activate the Layout or Format tab, and choose the Vertical (Value) Axis from the dropdown in the top left of the ribbon. (Yes, it's there even though it's a flat contour chart). Press CTRL+1 (numeral one) to open the Format Axis dialog, and adjust the scale here. is there a way to get rid of the 3-D look of 2007? Don't you hate that? It's absolutely miserable. This is a royal pain to fix. You have to do this for each series: Select the corresponding legend entry for the series, and press CTRL+1 to format it. Select 3D Format from the items on the left edge of the dialog, then under Surface Material, choose Flat (third one in the Special Effect row). Ironic that Flat is a special effect. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Randy" wrote in message ... How do you set the contour plot z-axis legend scale in 2007? In 2003 I could double click on the legend and then select the bottom point, range between points and top point of the z-axis scale. Also, is there a way to get rid of the 3-D look of 2007 and go back to the 2003 countour plot look with flat/uniform colors for a given range of data? |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Nice. I was assuming I'd have to loop through the series collection to
format the series individually. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Christopher Scott [MSFT]" wrote in message ... The 97-2003 file format is a good find. You can also turn the 3-D effect for a chart all at once through automation by running in Visual Basic: ActiveChart.ChartGroups(1).Has3dShading = False -- Thanks, Christopher This posting is provided "AS IS" with no warranties, and confers no rights. "Randy" wrote: Thanks Jon! Who would have guessed that the Y-axis is elevation on a contour plot?! I also found that if I saved the file in 2003 format the 3D shading went away. Still used a bad color selection for depicting the data but it is at least a quick way to get them all to change at once. Randy "Jon Peltier" wrote: How do you set the contour plot z-axis legend scale in 2007? Activate the Layout or Format tab, and choose the Vertical (Value) Axis from the dropdown in the top left of the ribbon. (Yes, it's there even though it's a flat contour chart). Press CTRL+1 (numeral one) to open the Format Axis dialog, and adjust the scale here. is there a way to get rid of the 3-D look of 2007? Don't you hate that? It's absolutely miserable. This is a royal pain to fix. You have to do this for each series: Select the corresponding legend entry for the series, and press CTRL+1 to format it. Select 3D Format from the items on the left edge of the dialog, then under Surface Material, choose Flat (third one in the Special Effect row). Ironic that Flat is a special effect. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Randy" wrote in message ... How do you set the contour plot z-axis legend scale in 2007? In 2003 I could double click on the legend and then select the bottom point, range between points and top point of the z-axis scale. Also, is there a way to get rid of the 3-D look of 2007 and go back to the 2003 countour plot look with flat/uniform colors for a given range of data? |
#7
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi, your post were quite helpful. Thanks
I have another problem, I would like to change the x axis labelling. Now in my case i am changing a parameter c from 1 to 2 in intervals of 0.1 in the series data, I would like that the labeling in the x axis is 1, 1.1, 1.2, 1.3...etc. I tried from the format axis but only whole numbers are allowed (interval between tick marks/ specify interval unit). Is there a way to go about this? I have a similiar problem with the y axis - on the y axis i am changing a parameter d from 1 to 2 again. The axis labeling is series 1, series 2,.. etc. Now i would like to change it to 1, 1.1, 1.2 ..etc. I guess I have to change each series name manually from the select data tab. Thanks a lot "Jon Peltier" wrote: Nice. I was assuming I'd have to loop through the series collection to format the series individually. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Christopher Scott [MSFT]" wrote in message ... The 97-2003 file format is a good find. You can also turn the 3-D effect for a chart all at once through automation by running in Visual Basic: ActiveChart.ChartGroups(1).Has3dShading = False -- Thanks, Christopher This posting is provided "AS IS" with no warranties, and confers no rights. "Randy" wrote: Thanks Jon! Who would have guessed that the Y-axis is elevation on a contour plot?! I also found that if I saved the file in 2003 format the 3D shading went away. Still used a bad color selection for depicting the data but it is at least a quick way to get them all to change at once. Randy "Jon Peltier" wrote: How do you set the contour plot z-axis legend scale in 2007? Activate the Layout or Format tab, and choose the Vertical (Value) Axis from the dropdown in the top left of the ribbon. (Yes, it's there even though it's a flat contour chart). Press CTRL+1 (numeral one) to open the Format Axis dialog, and adjust the scale here. is there a way to get rid of the 3-D look of 2007? Don't you hate that? It's absolutely miserable. This is a royal pain to fix. You have to do this for each series: Select the corresponding legend entry for the series, and press CTRL+1 to format it. Select 3D Format from the items on the left edge of the dialog, then under Surface Material, choose Flat (third one in the Special Effect row). Ironic that Flat is a special effect. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Randy" wrote in message ... How do you set the contour plot z-axis legend scale in 2007? In 2003 I could double click on the legend and then select the bottom point, range between points and top point of the z-axis scale. Also, is there a way to get rid of the 3-D look of 2007 and go back to the 2003 countour plot look with flat/uniform colors for a given range of data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there an add-in to depict correlation matrices as contour plots | Excel Discussion (Misc queries) | |||
How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
user defined scale for surface plots | Charts and Charting in Excel | |||
Disable warning for negative numbers on log scale plots | Excel Discussion (Misc queries) | |||
contour plots | Charts and Charting in Excel |