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
 
Back
Top