| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plot 7 bars and 1 line on a chart
How do I use the combo chart to plot 7 bars and 1 line on a chart? Excel
wants to make it to be a 4 bar and 3 line chart. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Plot 7 bars and 1 line on a chart
Select the first line/series you want to be a column, then Chart/Chart Type,
and making sure "Apply to selection" is chosen, select Column chart. Press the up arrow (selects the next series), then press F4 (repeats changing that line to a column), and so on until you've only got one line left. Bob Umlas Excel MVP "BigBunny" wrote in message ... How do I use the combo chart to plot 7 bars and 1 line on a chart? Excel wants to make it to be a 4 bar and 3 line chart. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Plot lines between plot points on a line chart | Charts and Charting in Excel | |||
| Up/down Bars - Line Chart | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
| Can a combo chart plot 4 variables? (3 bars,1 line) | Charts and Charting in Excel | |||
| How to display chart with three bars and one line? | Charts and Charting in Excel | |||
Linear Mode
