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?
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.
Thanks for the help !
There are currently 9 users browsing this thread. (0 members and 9 guests)
Posting Permissions
Reply With Quote
Bookmarks