View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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