|
|||||||||||||||||||||
|
#1
|
|||
|
|||
|
Bar - Line Graph Combo
I have four data sets that I want to graph with a bar - line graph.
I want to have three of the data sets graphed with a bar graph on the primary axis. The last data set, I want graphed with a line graph on the secondary axis. My problem is that I can get two of the three data sets showing as bar graphs. The third data set wants to show itself as a line graph. How can I get all three data sets to show as a bar graph while keeping the last data set as showing as a line graph? |
|
#2
|
||||
|
||||
|
If you are trying to use the built-in combination charts, don't.
It's much easier to create your own combination chart. Select all the data and create a bar chart. Select and change the last series to Line Format the line series to be on the Secondary axis. |
|
#3
|
|||
|
|||
|
Thanks for the help !
|
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|