ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Is this possible - 2 times 2 variables (https://www.excelbanter.com/charts-charting-excel/175350-possible-2-times-2-variables.html)

Maxime Maugeais

Is this possible - 2 times 2 variables
 
Hello,

I would like to have a stacked column chart to represent the following:
RTL JBOS
Input 30 109


Train No Train
Output 134 29

What I would like is for the first stack to be called "Input" and represent
RTL+JBOS and have a second stack called "Output" represent Train + No Train.

The idea is that the stack "input" should be the same height a the stack
"output". Given the numbers above, they are not equal and I want to
illustrate the difference.

Is this possible?

Thank you

Del Cotter

Is this possible - 2 times 2 variables
 
On Fri, 1 Feb 2008, in microsoft.public.excel.charting,
Maxime Maugeais said:
What I would like is for the first stack to be called "Input" and represent
RTL+JBOS and have a second stack called "Output" represent Train + No Train.


Is this possible?


Yes. Just think of two columns as having *four* stacked blocks, where
the first column has values only for RTL and JBOS, and the second column
has values only for Train and No Train:

RTL JBOS Train No Train
Input 30 109
Output 134 29

Voila!

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Maxime Maugeais

Is this possible - 2 times 2 variables
 
Worked like a charm.

Thanks a lot.

Though I have to admit, I am not too impressed with myself for not thinking
about it.

Cheers

"Del Cotter" wrote:

On Fri, 1 Feb 2008, in microsoft.public.excel.charting,
Maxime Maugeais said:
What I would like is for the first stack to be called "Input" and represent
RTL+JBOS and have a second stack called "Output" represent Train + No Train.


Is this possible?


Yes. Just think of two columns as having *four* stacked blocks, where
the first column has values only for RTL and JBOS, and the second column
has values only for Train and No Train:

RTL JBOS Train No Train
Input 30 109
Output 134 29

Voila!

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.



All times are GMT +1. The time now is 10:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com