Forum Discussion
Lukas69
Jul 11, 2022Copper Contributor
Graph with two y axis acess to same x value
Hi guys, I´m trying to create a graph. I have several Products sold in several locations. I want to display in one graph the turnover and also the change in percent point compared to the month be...
- Jul 11, 2022
On the Chart Design tab of the ribbon, select Add Chart Element > Axes > Secondary Horizontal.
Double-click the secondary horizontal axis (it is displayed at the top).
Under Axis Options, expand Labels, and set Label Position to None.
Lukas69
Jul 11, 2022Copper Contributor
HansVogelaar
Thank you very much. That is exatcly what I'm looking for.
Unfortunately I can not reconstruct how you did it.
in your file:
I select A5:D8 and insert a Clustered Column
Than I go on chart filters Select Data Source -> Add series name ="changes" series Y values =B11:B21 and series x values is empty.
Afterwards I change the chart typ to Combo, everything cluster but changes as Scatter and as secondary axis.
As result I get the same chart as before.
Where is my mistake or what additional step is necessary?
Thank you very much. That is exatcly what I'm looking for.
Unfortunately I can not reconstruct how you did it.
in your file:
I select A5:D8 and insert a Clustered Column
Than I go on chart filters Select Data Source -> Add series name ="changes" series Y values =B11:B21 and series x values is empty.
Afterwards I change the chart typ to Combo, everything cluster but changes as Scatter and as secondary axis.
As result I get the same chart as before.
Where is my mistake or what additional step is necessary?
HansVogelaar
Jul 11, 2022MVP
On the Chart Design tab of the ribbon, select Add Chart Element > Axes > Secondary Horizontal.
Double-click the secondary horizontal axis (it is displayed at the top).
Under Axis Options, expand Labels, and set Label Position to None.
- Lukas69Jul 12, 2022Copper ContributorHansVogelaar
thank you very much. That does the trick.