Very complex chart !

  • Thread starter Thread starter Hande
  • Start date Start date
H

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!
 
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.
 
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/
_______
 
Back
Top