Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
How can I create a chart that has a value x,y, and z axis. I want to put
numbers on the left side of the chart, at the bottom, as well as on the right side. Right now it only allows me to put information on the x and y axis. How can I change it? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Té -
How can I create a chart that has a value x,y, and z axis. < You can't. Excel has three kinds of "true" 3-D charts: 3-D Column, 3-D Surface, and Wireframe 3-D Surface. For all three, the x and y axes are "category" or label axes, and only the z axis is a value axis. When the chart is created, the labels on the x and y axes are necessarily equally-spaced. If the x and y data have values that are equally-spaced, then the chart may be a good representation. - Mike http://www.MikeMiddleton.com "Té" wrote in message ... How can I create a chart that has a value x,y, and z axis. I want to put numbers on the left side of the chart, at the bottom, as well as on the right side. Right now it only allows me to put information on the x and y axis. How can I change it? |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
It sounds as if you want a secondary y axis, rather than a z axis (as the
latter would apply to a 3D chart). If you want a secondary y axis, select one of the series on your chart, then Format Series/ Axis, and select secondary axis. -- David Biddulph "Té" wrote in message ... How can I create a chart that has a value x,y, and z axis. I want to put numbers on the left side of the chart, at the bottom, as well as on the right side. Right now it only allows me to put information on the x and y axis. How can I change it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
remove characters on both sides | Excel Worksheet Functions | |||
area of a rectangle having two sides equal and two sides diffferen | Excel Worksheet Functions | |||
display value axis on both sides | Charts and Charting in Excel | |||
i want to print using both sides of A4 sheet | Excel Discussion (Misc queries) | |||
tick marks on all 4 sides of an x-y chart | Charts and Charting in Excel |