Line-bar chart on 2 axis

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

George Wilson

I have a line chart representing data correctly on one
axis. I add the line for the secondary axis and it looks
fine, I change it to bars and it does not span the full
length of the Y axis. It gets shortened to half its
original length. The custom line-bar chart provided with
excel is not working either. I have over 1000 plot points
on one axis and only 23 on the secondary axis, could this
be afecting the chart from displaying properly?
TIA
George
 
You should be able to change the display by adjusting the min. / max.
values of the secondary y-axis (double-click the secondary y-axis, then
select the Scale tab).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
multiple series bar and line chart 2
Help with Bar-Line Chart..not aligned?? 1
vertical scale on both ends of bar chart 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Coordinate secondary y axis to primary y axis 2
how do you change the way a series in plotted on a secondary axis 1
Make Y-axis values correspond to x- axis value 1

Back
Top