Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart legend names in a chart itself
How do I include in a line chart the legend names of the data lines?
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart legend names in a chart itself
In article , Word-
says... How do I include in a line chart the legend names of the data lines? Select the chart, then Chart | Chart Options... | Legend tab | check the 'Show Legend' checkbox and adjust optional properties. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart legend names in a chart itself
If you already have a legend, but it says "Series 1", "Series 2", etc., you
never assigned series names. In an existing chart, go to Chart menu Source Data Series tab, select a series, click in the box next to Name, and type a name or select a cell containing the name of the series. Repeat for all of the series. For a new chart, if you set up the data appropriately, Excel will do this for you. With series data in columns, put the category labels in the first column of the data, put series names in the top row, and keep the top left cell blank. Select the whole range, including top row and left column, then run the chart wizard. The blank cell helps Excel parse the range and extract series names and category labels accurately. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Word-Dancer" wrote in message ... How do I include in a line chart the legend names of the data lines? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart legend names in a chart itself
Do the following:
1. Right-click the chart, and click Chart Options 2. Click the Chart Options dialog box, click the Data Labels tab. 3. Under Label Contains, select the Series name and Category name checkboxes. If required, select the Legend Key to display the legend color associated to that Data series value. 4. Click OK The chart displays the Series name and the Values names at each data poins in the line - Which ever chart type you select. Challa Prabhu "Word-Dancer" wrote: How do I include in a line chart the legend names of the data lines? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto show a line on a chart by clicking on a legend key | Charts and Charting in Excel | |||
How do I separate a chart from its legend | Charts and Charting in Excel | |||
Strange behaviour with legend in 2-Sided Chart | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |