Forum home » Delegate support and help forum » Microsoft Excel Training and help » Changing the axis infromation in an Excel graph
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Changing the axis infromation in an Excel graph
Resolved · High Priority · Version 2007
Reply Tue 28 Jun 2011, 14:30Delegate Nicky said...
Nicky has attended:
Excel Intermediate course
Changing the axis infromation in an Excel graph
Hi
I am currently using a line graph to display training course data as follows
No of delegates
No of delegate hours
No of training courses
As the number of training courses is much lower than the other figures its getting lost at the bottom, is there any way to change the Axis numbers at the bottom of the graph to highligh this data?
Thanks
Nicky
For upcoming training course dates see: Pricing & availability
RE: Changing the axis infromation in an Excel graph
Hi Nicky, thanks for your query. You can't alter the scale at the bottom of the y-axis (unless you do it graphically) but try this. Click once on the "No of training courses" line, then right click on it and Format Data Series. Then choose Plot on Secondary Axis. That will give you another axis on the right of the chart and the "No of training courses" should be much clearer on the chart.
Hope this helps,
Anthony
|