Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a Line-Column on 2 Axis chart that allows more...
How do I create a Line-Column on 2 Axis chart that allows to have more than
one line? I am looking to have one data point as a column and two data points as lines, but I can' do the two lines. thanks! |
#2
|
|||
|
|||
Ang -
Why settle for an inflexible built in combination chart, when you can easily make one the way you want? Select your data, and make a Column chart. Select a series you want as a line, choose Chart Type from the Chart menu, and choose a Line style you want. Select the next one to turn to a line and repeat (the F4 key is a shortcut to repeat). When you've changed the desired series to lines, double click on one line series, and on the Axis tab, select Secondary. Select the next line series and repeat (F4 key). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Angioletta wrote: How do I create a Line-Column on 2 Axis chart that allows to have more than one line? I am looking to have one data point as a column and two data points as lines, but I can' do the two lines. thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add line to a stacked area chart already created | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |