Legend - Don't Want To See

#1 10-07-2005, 12:05 AM

In "Chart Options" for Legends, I Uncheck
'Show Legend" & I increase the width of the Chart.

BUT, reopening the File (after SAVING it),
"narrows" the Chart & puts the Legend back in.

Is there a way to NOT have a Legend??

TIA - Bob

#2 10-07-2005, 11:05 AM

what version of Excel do you have.
It does not do that on any of the versions I have worked with.

Is it in just one file that this happens or all files.

"Bob Barnes" wrote:

> In "Chart Options" for Legends, I Uncheck
> 'Show Legend" & I increase the width of the Chart.
>
> BUT, reopening the File (after SAVING it),
> "narrows" the Chart & puts the Legend back in.
>
> Is there a way to NOT have a Legend??
>
> TIA - Bob

#3 10-07-2005, 03:05 PM

bj - THANK you.

Excel 2003 - I've been told if I Uncheck Show Legend WHEN I build
the Chart, that will work - HAVEN'T tested yet.

Bob

"bj" wrote:

> what version of Excel do you have.
> It does not do that on any of the versions I have worked with.
>
> Is it in just one file that this happens or all files.
>
> "Bob Barnes" wrote:
>
> > In "Chart Options" for Legends, I Uncheck
> > 'Show Legend" & I increase the width of the Chart.
> >
> > BUT, reopening the File (after SAVING it),
> > "narrows" the Chart & puts the Legend back in.
> >
> > Is there a way to NOT have a Legend??
> >
> > TIA - Bob

#4 10-07-2005, 07:05 PM

We solved the problem by copying & pasting the two
worksheets into a new Workbook.

Thanks - Bob

"Bob Barnes" wrote:

> In "Chart Options" for Legends, I Uncheck
> 'Show Legend" & I increase the width of the Chart.
>
> BUT, reopening the File (after SAVING it),
> "narrows" the Chart & puts the Legend back in.
>
> Is there a way to NOT have a Legend??
>
> TIA - Bob

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)