ExcelBanter - View Single Post - Want graph with 2 axis, but bars overlap when second axis added

fra.car

Dear excel addicted,
Is my first post on this forum and I have retreived an old post to start. I hope it will be not considered as not polite :)

It's few days that I'm puzziling on this thread issue.
The solution provided by Jon in the link
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
almost fits my needs...but it's not enough!
In fact I need to show under the graph also the table with the data values. And here came the problem, because the table shows also the dummy series..
Very odd!!!

Anyone has a solution?

Thanks and greetings from Italy

Francesco

Quote:

Originally Posted by Jon Peltier

Yeah, I need a better way to navigate through all of my examples. Maybe
I could adapt the ribbon-type user interface?

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

Andy Pope wrote:

Thanks Jon, I couldn't see that example for looking :)

Jon Peltier wrote:

Actually, this is more likely to be helpful:

http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

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

Andy Pope wrote:

Hi,

Here is one example.
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

Gill wrote:

I need to have a bar graph with two data sets of different scales,
yet when I change one data set to an secondary axis, the two bars
combine. I need them to be sitting side by side.

thanks