LinkBack URL
About LinkBacks
Hi all ,
I am trying to create a chart that has 2 y-axis data series sharing a common x-axis. I have been trying to add a secondary y-axis for second data series. How do I do this please?
Hi all ,
I am trying to create a chart that has 2 y-axis data series sharing a common x-axis. I have been trying to add a secondary y-axis for second data series. How do I do this please?
Select graph line and right click on it -> Format Data Series -> Secondary Axis (under Series Options)
Never use Merged Cells in Excel
Hi zbor,
thanks for for post: I tried this but got the following:
chart.png
You now have a secondary Y axis, you just need to format it however you wish.
Everyone who confuses correlation and causation ends up dead.
Just anticipating a bit:
if you want your bars next to each other, the easiest way will be to add 2 empty series (one drawn on main, second on secondary axis, because otherwise it is not easy to move the bars left or right)
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks