Legend Lines

  • Thread starter Thread starter John M
  • Start date Start date
J

John M

Hello,

I am preparing an Excel line graph that must be quite
small to fit into the space available on a report.
Everything works fine, except for the legend line which is
much too long. If I drag the legend box sideways to be
smaller, the text drops down to the next line and I have
to make the box longer. I have been searching for an hour
to figure out how to make the legend line itself smaller,
with no luck. Any ideas?

Thanks, John
 
John said:
I am preparing an Excel line graph that must be quite
small to fit into the space available on a report.
Everything works fine, except for the legend line which is
much too long.... I have been searching for an hour
to figure out how to make the legend line itself smaller,
with no luck. Any ideas?
Click to expand...

As you have already found out, I don't think Excel allows this change. It
may be possible via code, but I don't know how.

You could potentially delete the default legend and create your own using a
dummy series. For one of the series, create a dummy series with one data
point and use a dashed line formatted like your real series. One dash will
appear on the chart. Then use a chart labeler like the one on
www.appspro.com to label that data point with the text you want.

For more fun with dummy series, see
http://www.geocities.com/jonpeltier/Excel/Charts/DummySeries.html.

Dave
dvt at psu dot edu
 
John -

Another idea: does it help to use a smaller font, or a narrower one,
like Arial Narrow?

- Jon
 
Back
Top