If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 -- leperm ------------------------------------------------------------------------ leperm's Profile: http://www.excelforum.com/member.php...o&userid=31805 View this thread: http://www.excelforum.com/showthread...hreadid=515281 |
#2
|
|||
|
|||
Legend does not work
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 |
#3
|
|||
|
|||
Legend does not work
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Please Help?? Auto Update Field in table | A. Smart | General Discussion | 8 | February 2nd, 2006 01:19 PM |
How to copy the work sheets from different workbooks into one? | Sesh | General Discussion | 1 | April 15th, 2005 06:03 PM |
how do I create a work order form | cher952 | Using Forms | 1 | March 14th, 2005 05:09 PM |
Work Areas in a database | LMB | New Users | 3 | October 4th, 2004 11:31 PM |
add legend | PKT | Visio | 12 | September 29th, 2004 10:55 AM |