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
|
|||
|
|||
change the format of a series in a chart
I am using a standard combination chart (column/line) to present some data
that is based on 6 individual series from an Excel spreadsheet. The Chart Wizard has arranged the data so that three series are presented as lines and the remaining three are presented as columns. My dilemma is that one of those series presented as columns I want to be presented as a line. In total, I want two series as columns and four as lines. Can this be done? What do I need to do in order to change the data from a column to a line? Thanks in anticipation. Regards, Cliff |
#2
|
|||
|
|||
change the format of a series in a chart
Hi,
Right click the column that you want to change and use the Chart Type option to select the required line chart style. Cheers Andy CliffD wrote: I am using a standard combination chart (column/line) to present some data that is based on 6 individual series from an Excel spreadsheet. The Chart Wizard has arranged the data so that three series are presented as lines and the remaining three are presented as columns. My dilemma is that one of those series presented as columns I want to be presented as a line. In total, I want two series as columns and four as lines. Can this be done? What do I need to do in order to change the data from a column to a line? Thanks in anticipation. Regards, Cliff -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't format all data series on chart | PaB | General Discussion | 0 | August 9th, 2005 07:22 PM |
Fan charts | Dean | Charts and Charting | 7 | May 30th, 2005 11:51 AM |
change animation series in chart | ET902 | Powerpoint | 0 | March 18th, 2005 04:19 PM |
set chart series to RGB color in PowerPoint | [email protected] | Powerpoint | 0 | March 1st, 2005 06:28 AM |
add vertical line to floating bar chart, still trying | bbxrider | Charts and Charting | 6 | January 27th, 2004 11:42 PM |