| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging 2 Graphs
I have a table as follows:
Branch Amt Qty Rate A 100 20 10% B 200 15 12% C 400 12 11% with a bar chart showing two "BARs" for Amt & Qty, and a line graph for Rate. Can I merge the graphs in one with two bars and one line? Thanx in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merging 2 Graphs
make a bar chart with all three variables
Select the rate bar and chart-chart type-select line. you will probably also have to double click on the line and select axis secondary to get the y axis how you want it. "FARAZ QURESHI" wrote: I have a table as follows: Branch Amt Qty Rate A 100 20 10% B 200 15 12% C 400 12 11% with a bar chart showing two "BARs" for Amt & Qty, and a line graph for Rate. Can I merge the graphs in one with two bars and one line? Thanx in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
| Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel | |||
| When merging information not merging correctly | Excel Worksheet Functions | |||
| Sorting, Merging, and Re-merging | Excel Worksheet Functions | |||
| Line Graphs and Bar Graphs | Excel Discussion (Misc queries) | |||
Linear Mode
