ExcelBanter - How i add axis ( z ) in 2D XY chart

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How i add axis ( z ) in 2D XY chart (https://www.excelbanter.com/excel-worksheet-functions/153375-how-i-add-axis-z-2d-xy-chart.html)

ARNABCHAK

How i add axis ( z ) in 2D XY chart

Dear Sir/Madam,
Please let me know how i add axis (z) in 2D XY chart IN Ms-Excel.
Thanks.

Sean Timmons

How i add axis ( z ) in 2D XY chart

You can;'t have 3 axes in a 2d chart. Are you looking to, say, have a bar
graph, then a line to indicate, say, goal? That would be a column-area under
Custom Types tab.

"ARNABCHAK" wrote:

Dear Sir/Madam,
Please let me know how i add axis (z) in 2D XY chart IN Ms-Excel.
Thanks.

Mike Middleton

How i add axis ( z ) in 2D XY chart

ARNABCHAK -

The XY (Scatter) chart type has a numerical X axis and a numerical Y axis.

The 3-D Column chart type and the Surface chart types have a numerical Z
axis and equally-spaced category X and Y axes.

Excel does not have a true 3D chart with X, Y, and Z numerical axes.

- Mike
www.MikeMiddleton.com

"ARNABCHAK" wrote in message
...
Dear Sir/Madam,
Please let me know how i add axis (z) in 2D XY chart IN Ms-Excel.
Thanks.

Mike Middleton

How i add axis ( z ) in 2D XY chart

All times are GMT +1. The time now is 05:28 AM.