Line-bar chart on 2 axis

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
 
T

Tushar Mehta

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
 

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

Help with Bar-Line Chart..not aligned?? 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Odd chart type needed 2
vertical scale on both ends of bar chart 1
Make Y-axis values correspond to x- axis value 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Coordinate secondary y axis to primary y axis 2
Anyway to plot a stacked bar and bar chart on Primary and Secondary axis? 2

Top