Very complex chart !

[Hande]

Hi everyone,

I have a data table like this:

Jan Feb March

Actual EUR Vol
Actual USD Vol(in EUR)
Plan EUR Vol
Plan USD VOL (in EUR)

The management wants to see its chart this way:
First bar,2 colors for EUR&USD Actuals
Second bar,2 colors for EUR&USD Plan

I am stuck! Please help!

 

[Jon Peltier]

Hande -

There are links on this page which will help with your chart:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

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

 

[bobf]

A simpler way than john peltier's is to plot all 4 as a
stacked bar, setting the unwanted two to zero. You will
need to duplicate each column, and in the second column,
set the other pair to zero.

 

[Jon Peltier]

Bob -

You have to clarify a bit. I don't see how this provides the desired
appearance.

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