Brett has attended:
Excel Intermediate course
Graphs
How do I have a vertical axis going up from a horizontal axis and also going down so in affect 2 graphs in one with same horizontal axis.
RE: Graphs
Hi Brett
Can I just check. Do you want to set up a graph witrh two vertical axis which share the same horizontal axis?
If so see example attached.
How to set up a chart with 2 vertical axis
First create a normal column chart
Right click on the series you want to be the Secondary vertical axis (in my case temperature)
Choose Format Data Series
Select Secondary Axis
If you want to make the second series a line chart click Change Chart type while the second series is still selected and choose a line chart style.
To add a Secondaty axis title select Layout, Axit Titles
Secondary, Vertical Axis Title, Rotated Title.
Hope that helps. If not please send your example by clicking Upload after posting your reply.
Regards
Doug Dunn
Best STL