Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Specifying chart graph
How can I specify on the same chart which fields I want to be displayed as
Column and which fields I want to be displayed as Line? I have over seven fields. Let's say I want columns B through E to be columns and the other columns to be lines. Thanks in advance. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Specifying chart graph
Forget about the built-in custom types. Make a column chart. Then select a
series you want to change to a line, choose Chart Type from the Chart menu, and choose a line style. Select another you want to change and press the F4 function key, and repeat as required. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "SJ" wrote in message ... How can I specify on the same chart which fields I want to be displayed as Column and which fields I want to be displayed as Line? I have over seven fields. Let's say I want columns B through E to be columns and the other columns to be lines. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart gridlines over an area graph | Charts and Charting in Excel | |||
Need help with chart graph not on chart wizard | Charts and Charting in Excel | |||
Assistance in making a chart graph that is not on wizard | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) |