Legend does not work

Hi,
Spent an hour looking into this. Not sure if this is a known bug or not.
The legend for the graph is not working correctly...I have the following cells graphed :
USA
Jan-90 3.1
Feb-90 3.4
Mar-90 2.1
etc...

When I click legend it displays every single date in the first column rather than "USA". I've tried to manually call the series USA, erase the first column, recreate the range but it still doesn't work. This is crazy and excel help is useless. I've followed all the steps in excel help but they don't solve the problem.
Anyone have any ideas on why it is using the dates as the legend?
Thanks

Hi,

With data laid out like this,
B1: =USA
A2: =Jan-90 B2: =3.1
A3: =Feb-90 B3: =3.4
A4: =Mar-90 B4: =2.1

Selecting range A1:B4 and when going through the chart wizard on step 2
of 4 on the Data Range tab make sure 'Series in:' Columns is selected.
This then gives me legend of USA and axis labels of the dates.

Cheers
Andy

leperm wrote:
> Hi,
> Spent an hour looking into this. Not sure if this is a known bug or
> not.
> The legend for the graph is not working correctly...I have the
> following cells graphed :
> USA
> Jan-90 3.1
> Feb-90 3.4
> Mar-90 2.1
> etc...
>
> When I click legend it displays every single date in the first column
> rather than "USA". I've tried to manually call the series USA, erase
> the first column, recreate the range but it still doesn't work. This is
> crazy and excel help is useless. I've followed all the steps in excel
> help but they don't solve the problem.
> Anyone have any ideas on why it is using the dates as the legend?
> Thanks
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Also don't enable "Vary Colors by Point" (Format Series > Options tab).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Andy Pope" <[email protected]> wrote in message
news:%[email protected]...
> Hi,
>
> With data laid out like this,
> B1: =USA
> A2: =Jan-90 B2: =3.1
> A3: =Feb-90 B3: =3.4
> A4: =Mar-90 B4: =2.1
>
> Selecting range A1:B4 and when going through the chart wizard on step 2 of
> 4 on the Data Range tab make sure 'Series in:' Columns is selected.
> This then gives me legend of USA and axis labels of the dates.
>
> Cheers
> Andy
>
> leperm wrote:
>> Hi,
>> Spent an hour looking into this. Not sure if this is a known bug or
>> not. The legend for the graph is not working correctly...I have the
>> following cells graphed : USA
>> Jan-90 3.1
>> Feb-90 3.4
>> Mar-90 2.1
>> etc...
>>
>> When I click legend it displays every single date in the first column
>> rather than "USA". I've tried to manually call the series USA, erase
>> the first column, recreate the range but it still doesn't work. This is
>> crazy and excel help is useless. I've followed all the steps in excel
>> help but they don't solve the problem. Anyone have any ideas on why it is
>> using the dates as the legend?
>> Thanks
>>
>>
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info