3-Axis Y Chart Excel Solved

Question

Hello,

I am currently looking for a way to create a chart with 3 Y axes in Excel 2003. I want to show 2 curves (Revenue and Profit) and a histogram (Headcount), all for the same period.
The X axis is fine, but so far I can only overlay my 2 curves using the "2-axis charts" tool in custom types. I am therefore missing the histogram that I want to add to the same chart.

Thank you for your help.

Configuration: Windows XP / Internet Explorer 7.0

Pascal · Accepted Answer

Build the chart with the 3 data series, type curves
Select the series to modify by double-clicking
In the axis selection tab, check Secondary Axis, then OK
In the chart menu, select chart type, histogram. It will only apply to the selected series.

tontong · Answer

Hello,
With Excel, you will need to limit yourself to 2 y-axes and "ruser" to obtain a readable representation. For example, replace the "profit" curve with a curve (revenue - profit). You could also multiply the profit by ten, but that would be misleading and overly optimistic ;-)

3-Axis Y Chart Excel

2 answers

Problem with open office spreadsheet

How to pair a receiver with an external speaker without fi

Invisible text boxes or word forms on pdf

Pdf modification: online services and free programs

Reserve your whatsapp username for more privacy

Disable audio dubbing

I can't even find a single string.

Toshiba c70d-a-111 image/recovery disk search

Print a page in the right orientation under windows 11

My computer stays connected for very little time