Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dual Axis Horizontal Bar Chart in Excel-can I avoid overlapping ba
hello,
I have a simple table of data with 2 columns of numbers, which I'm trying to build into a simple horizontal bar chart Problem is that the 1 column's numbers are much greater than the other, so this means that makes the smaller series' bars look very small. I would like to see both displayed together however, but if I put it on a secondary axis it overlays one on top of the other, rather than side-by-side Is there an easy way to stop this happening? any help would be greatly appreciated cheers griff |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dual Axis Horizontal Bar Chart in Excel-can I avoid overlapping ba
This link shows how to handle this with column charts. For bar charts the
approach is very similar. http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "griff" wrote in message ... hello, I have a simple table of data with 2 columns of numbers, which I'm trying to build into a simple horizontal bar chart Problem is that the 1 column's numbers are much greater than the other, so this means that makes the smaller series' bars look very small. I would like to see both displayed together however, but if I put it on a secondary axis it overlays one on top of the other, rather than side-by-side Is there an easy way to stop this happening? any help would be greatly appreciated cheers griff |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dual Axis Horizontal Bar Chart in Excel-can I avoid overlappin
thanks jon - was hoping there was an options button that i was missing, but i
should have known better! cheers! griff "Jon Peltier" wrote: This link shows how to handle this with column charts. For bar charts the approach is very similar. http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "griff" wrote in message ... hello, I have a simple table of data with 2 columns of numbers, which I'm trying to build into a simple horizontal bar chart Problem is that the 1 column's numbers are much greater than the other, so this means that makes the smaller series' bars look very small. I would like to see both displayed together however, but if I put it on a secondary axis it overlays one on top of the other, rather than side-by-side Is there an easy way to stop this happening? any help would be greatly appreciated cheers griff |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dual Axis Horizontal Bar Chart in Excel-can I avoid overlapping ba
On Wed, 5 Dec 2007, in microsoft.public.excel.charting,
griff said: I have a simple table of data with 2 columns of numbers, which I'm trying to build into a simple horizontal bar chart but if I put it on a secondary axis it overlays one on top of the other, rather than side-by-side Is there an easy way to stop this happening? any help would be greatly appreciated The best way is to create a pair of phantom bars, one on each axis. They're both zero (or formatted to be invisible), and each one "overlays" the bar that you want to display on the other axis. But because they're zero or invisible, they're not overlaying or covering anything, so you get the effect you want, which is your two actual bars lying side-by-side. Jon Peltier shows how to do it he http://peltiertech.com/Excel/Charts/...OnTwoAxes.html -- 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. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dual Axis Horizontal Bar Chart in Excel-can I avoid overlappin
forgot to mention that one of the sets of numbers has a couple of negative values - had some great fun manually tweaking the scale to get them to match! "Jon Peltier" wrote: This link shows how to handle this with column charts. For bar charts the approach is very similar. http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "griff" wrote in message ... hello, I have a simple table of data with 2 columns of numbers, which I'm trying to build into a simple horizontal bar chart Problem is that the 1 column's numbers are much greater than the other, so this means that makes the smaller series' bars look very small. I would like to see both displayed together however, but if I put it on a secondary axis it overlays one on top of the other, rather than side-by-side Is there an easy way to stop this happening? any help would be greatly appreciated cheers griff |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dual Axis Horizontal Bar Chart in Excel-can I avoid overlappin
thanks del, but i'm afraid jon p already beat you to the same answer!
if however you can find a way to avoid manually messing around with scales to make the x axes align when you have negative values then that would be even better! cheers griff "Del Cotter" wrote: On Wed, 5 Dec 2007, in microsoft.public.excel.charting, griff said: I have a simple table of data with 2 columns of numbers, which I'm trying to build into a simple horizontal bar chart but if I put it on a secondary axis it overlays one on top of the other, rather than side-by-side Is there an easy way to stop this happening? any help would be greatly appreciated The best way is to create a pair of phantom bars, one on each axis. They're both zero (or formatted to be invisible), and each one "overlays" the bar that you want to display on the other axis. But because they're zero or invisible, they're not overlaying or covering anything, so you get the effect you want, which is your two actual bars lying side-by-side. Jon Peltier shows how to do it he http://peltiertech.com/Excel/Charts/...OnTwoAxes.html -- 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. |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dual Axis Horizontal Bar Chart in Excel-can I avoid overlappin
On Wed, 5 Dec 2007, in microsoft.public.excel.charting,
griff said: thanks del, but i'm afraid jon p already beat you to the same answer! if however you can find a way to avoid manually messing around with scales to make the x axes align when you have negative values then that would be even better! Well, because you've created an invisible bar in each axis, you have a way of making the two scales *automatically* match, no matter what data you put in. Provided, that is, that you went the route of formatting the bars to be "Border=None, Area=None" instead of having them contain zero values. Just have each invisible bar series be some scaled multiple (or fraction) of the same values as its visible doppelganger, and the scales will never mismatch, even when left on automatic. PS this works if the multiple in question is a power of ten, or five times a power of ten. For other scalings the zeroes sometimes end up misaligned. -- 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. |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dual Axis Horizontal Bar Chart in Excel-can I avoid overlappin
Griff -
How's this: http://peltiertech.com/Excel/Charts/AlignXon2Ys.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "griff" wrote in message ... thanks del, but i'm afraid jon p already beat you to the same answer! if however you can find a way to avoid manually messing around with scales to make the x axes align when you have negative values then that would be even better! cheers griff "Del Cotter" wrote: On Wed, 5 Dec 2007, in microsoft.public.excel.charting, griff said: I have a simple table of data with 2 columns of numbers, which I'm trying to build into a simple horizontal bar chart but if I put it on a secondary axis it overlays one on top of the other, rather than side-by-side Is there an easy way to stop this happening? any help would be greatly appreciated The best way is to create a pair of phantom bars, one on each axis. They're both zero (or formatted to be invisible), and each one "overlays" the bar that you want to display on the other axis. But because they're zero or invisible, they're not overlaying or covering anything, so you get the effect you want, which is your two actual bars lying side-by-side. Jon Peltier shows how to do it he http://peltiertech.com/Excel/Charts/...OnTwoAxes.html -- 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. |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dual Axis Horizontal Bar Chart in Excel-can I avoid overlappin
Thanks Jon & Del for your advice - most helpful!
cheers, Griff "Jon Peltier" wrote: Griff - How's this: http://peltiertech.com/Excel/Charts/AlignXon2Ys.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "griff" wrote in message ... thanks del, but i'm afraid jon p already beat you to the same answer! if however you can find a way to avoid manually messing around with scales to make the x axes align when you have negative values then that would be even better! cheers griff "Del Cotter" wrote: On Wed, 5 Dec 2007, in microsoft.public.excel.charting, griff said: I have a simple table of data with 2 columns of numbers, which I'm trying to build into a simple horizontal bar chart but if I put it on a secondary axis it overlays one on top of the other, rather than side-by-side Is there an easy way to stop this happening? any help would be greatly appreciated The best way is to create a pair of phantom bars, one on each axis. They're both zero (or formatted to be invisible), and each one "overlays" the bar that you want to display on the other axis. But because they're zero or invisible, they're not overlaying or covering anything, so you get the effect you want, which is your two actual bars lying side-by-side. Jon Peltier shows how to do it he http://peltiertech.com/Excel/Charts/...OnTwoAxes.html -- 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to avoid cell overlapping? | Excel Discussion (Misc queries) | |||
Excel Chart with Horizontal bars left and right of y-axis (2 datasets) | Charts and Charting in Excel | |||
Dual x-axis chart | Charts and Charting in Excel | |||
Chart with dual Y axis data | Excel Worksheet Functions | |||
How do I stop axis titles from overlapping with negative chart da. | Charts and Charting in Excel |