Customising Charts
 

Good Morning,

I have a chart showing different account information for different
departments.

I have 2 values per department, one showing value and the 2nd showing
hours.

Because of this I have created 2 axis. One going up every 200 and the
second axis is going up every 5,000.

The issue that I have is that I want the values to show side by side
but it keeps changing so that the figures are in one line per
department or one behind the other?

Does anyone know how I can change this so that they sit side by side
with 2 axis? Or even if it is possible.

Many thanks,


--
VickyC
------------------------------------------------------------------------
VickyC's Profile: http://www.excelforum.com/member.php...o&userid=27391
View this thread: http://www.excelforum.com/showthread...hreadid=500574

Customising Charts
 

This web page shows how to fix the column chart:

http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"VickyC" wrote in
message ...

Good Morning,

I have a chart showing different account information for different
departments.

I have 2 values per department, one showing value and the 2nd showing
hours.

Because of this I have created 2 axis. One going up every 200 and the
second axis is going up every 5,000.

The issue that I have is that I want the values to show side by side
but it keeps changing so that the figures are in one line per
department or one behind the other?

Does anyone know how I can change this so that they sit side by side
with 2 axis? Or even if it is possible.

Many thanks,


--
VickyC
------------------------------------------------------------------------
VickyC's Profile:
http://www.excelforum.com/member.php...o&userid=27391
View this thread: http://www.excelforum.com/showthread...hreadid=500574