Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I change a line series to a column series in excel?
Iam wanting 1 line series and 4 column series in my chart. All I keep getting
is 3 column series and 2 line. I can not figure out how to change a series type? |
#2
|
|||
|
|||
Hi,
Simplest way is to create a normal column chart using all 5 series of data. Then right click the column you want as a line. From the popup menu choose Chart Type. Select the required line chart style. Cheers Andy Mati wrote: Iam wanting 1 line series and 4 column series in my chart. All I keep getting is 3 column series and 2 line. I can not figure out how to change a series type? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In MS Excel, how do I change the column ref headers from numbers . | Excel Discussion (Misc queries) | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel | |||
how do I change the data series an an excel graph | Charts and Charting in Excel | |||
vlookup change column index position - without changing formulae | Excel Worksheet Functions |