Forum Discussion
Solved
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...
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.
This is the best I can do. It uses a separate range for the scatter chart series. It is plotted on the secondary x-axis and y-axis. The secondary x-axis labels have been set to None.
See the attached sample workbook.
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?
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.
- HansVogelaar
thank you very much. That does the trick.