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,

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" <VickyC.21ipta_1137063001.6689@excelforum-nospam.com> wrote in
message news:VickyC.21ipta_1137063001.6689@excelforum-nospam.com...
>
> 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
>