software

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 quot;USAquot;. 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--
leperm
------------------------------------------------------------------------
leperm's Profile: www.excelforum.com/member.php...oamp;userid=31805
View this thread: www.excelforum.com/showthread...hreadid=515281Hi,

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Also don't enable quot;Vary Colors by Pointquot; (Format Series gt; Options tab).

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