Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change column into lines on a Line-Column chart?
I want to create a chart with three columns and one line using two axis. Any
help would be useful. Thanks |
#2
|
|||
|
|||
Hi Ken,
Create a column chart based on all your data. Select the series that you want as line and right click it. Choose Chart Type and change it to Line. Now double click the new line so you can change the Axis value to secondary. Cheers Andy Ken wrote: I want to create a chart with three columns and one line using two axis. Any help would be useful. Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel change default column sort to current selection | Excel Worksheet Functions | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
On a combination chart how do i get 2 lines and 1 column? | Charts and Charting in Excel | |||
How to force continuous lines in line charts | Charts and Charting in Excel | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |