How to make a chart with 2 columns where each column has a different axis?

[kobyz]

Hello Everyone,
Lets say I have 2 types of Data (e.g one is quantity and the other one is in $) and I want to put them on the same plot.
What I need is 2 columns and a secondary axis.
So, I create a plot of columns with 2 adjacent columns where the measure of each column is on different axis.
I want to emphasize that I need 2 columns and not a column and a line.
You see the example picture at the attached file.

Thanks,
Koby



ColumnsTwoAxes_pic.png

[Kaper]

Add two extra columns and write some numbers there
then
1. made column graph of all data (4 columns)
2. format one of real series and one of "empty" series to be plotted on suplementary axis
3. Right click on a series and select graph data, then move "empty 2" series to the top of the list of series (Top is not necessary, above Value series would be enough)
4. delete all values in empty series
5. If legend is needed, then delete unwanted legend entries: click on a legend. Click on unwanted enrty. Press <Del>. Do the same with second unneeded entry

See attached file with intermediate steps presented

[kobyz]

Thanks a lot!
It was big help!

Koby

[Kaper]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[kobyz]

Where is this star? I cannot find it.

Thanks for your help, It did help a lot. I would still like to keep the question to see if
there are other solutions.

Koby