Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 75
Default Information on both sides of a chart

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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 762
Default Information on both sides of a chart

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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default Information on both sides of a chart

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
remove characters on both sides enrico via OfficeKB.com Excel Worksheet Functions 6 May 9th 23 07:45 PM
area of a rectangle having two sides equal and two sides diffferen Mr. Rai Excel Worksheet Functions 3 September 3rd 08 09:51 AM
display value axis on both sides pault Charts and Charting in Excel 1 March 16th 06 08:17 PM
i want to print using both sides of A4 sheet Rox Excel Discussion (Misc queries) 4 August 8th 05 09:01 PM
tick marks on all 4 sides of an x-y chart mickey Charts and Charting in Excel 1 May 2nd 05 11:09 AM


All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"