Answered: How did you get those two charts on a…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Method 1: Add Legend Entries

In this method, you need to add additional legend entries in the column chart.

Select the target area.
Next click the tab “Insert” in the ribbon.
After that, click the button “Column”.
And then in the drop-down list, choose the “Clustered Column”.
Right click the column of the series that you need to put to another column.
In the menu, choose the option “Format Data Series”.
In the “Format Data Series” window, choose the option “Secondary Axis” for this series.
And then close the window.
After that, right click the chart.
And then choose the option “Select Data” in the menu.
After that, right click the chart.
And then choose the option “Select Data” in the menu.
And then in the “Edit Series” window, input a series name into the textbox. Here we input the word “first”.
Now click “OK”.
Repeat the step 11-13 and add the second series.
After that, you can see that there are two new legend entries in the window. Click “OK” here.
Now right click the column in the chart.
Here click the option “Format Data Series” again.
In the window, change the series overlap for the column. And you can see the effect immediately in the chart. You can adjust it according to the actual result. In addition, you can also change the gap width if you need.
When you finish the change, close the window. Now you can see the result in the chart. The clustered column and stacked column are both in the chart.