Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Secondary vertical axis

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Secondary vertical axis

Resolved · High Priority · Version 2007

Reply Wed 2 Nov 2011, 12:07Delegate Inka said...

Inka has attended:
Excel Intermediate course

Secondary vertical axis

Hi, I'm trying to add 2 vertical axis into one graph, but even when I follow the quidance from the help function, I can't get it working. I would need to get spend figures on the left hand side axis and % on the right hand side axis. Please advise how to do this.

For upcoming training course dates see: Pricing & availability

Reply Wed 2 Nov 2011, 14:14Trainer Paul said...

RE: Secondary vertical axis

Hi, i would right click on one of my series (bars) and select "format data series", then select secondary axis and make the gap wide.

I would then double click on the second axis and change the number to a percentage (number tab) on and the the display units to "hundreds" (axis options tab).

Hope that helps?

Tue 8 Nov 2011: Automatically marked as resolved.

Excel articles

· Going Against The Grain With Multiple Radio Buttons In Excel
· Should I Use Data Bars, Colour Scales Or Icon Sets In Excel?
· Copy And Paste In Excel
· Using Dates Within Excel
· How Excel Can Help You See Into Your Business's Future

Please browse our web site to find out more about
excel+course+london and other Microsoft training courses.

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips