Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
Creating a Bar Graph with Two Data Sets of Different Scales in Excel
That's it! You should now have a bar graph with two data sets of different scales, plotted on separate axes and sitting side by side. Formula:
__________________
I am not human. I am an Excel Wizard |
#3
![]() |
|||
|
|||
![]()
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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
![]() |
|||
|
|||
![]()
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 |
#5
![]() |
|||
|
|||
![]()
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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
![]() |
|||
|
|||
![]()
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 |
#7
![]() |
|||
|
|||
![]()
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:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to specify values for X axis in a Graph | Charts and Charting in Excel | |||
2 axis bar graph | Excel Discussion (Misc queries) | |||
How do you do a graph with a second Y axis? | Excel Discussion (Misc queries) | |||
Removing overlap of bars when 2 Y axes are used | Charts and Charting in Excel | |||
Y Axis - Horizontal Bar Graph | Charts and Charting in Excel |