Making a line span the full length of a chart
Hi,
i have a chart with primary and secondary axis (a bar and line format). I want to make the line span the whole of the chart, stopping at the edges of the chart not before. Is there a way of doing this without manually drawin it on? I cant seem to find a way of making the line any longer. Thanks.... |
Making a line span the full length of a chart
Hi,
Assuming the line is on the secondary axis. Right click chart and pick Chart Options. On Axis tab enable secondary x axis. Double click secondary x axis and on the scale tab uncheck Value (y) axis crosses between categories. On the patterns tab set Line and Ticklabels to none. Cheers Andy KrisP wrote: Hi, i have a chart with primary and secondary axis (a bar and line format). I want to make the line span the whole of the chart, stopping at the edges of the chart not before. Is there a way of doing this without manually drawin it on? I cant seem to find a way of making the line any longer. Thanks.... -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 08:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com