Chart Examples- Series and Axis

Please purchase the course before starting the lesson.

Chart Examples- Series and Axis

Chart Ex 2

Using the chart given, do the following to make the chart look like this:

Chart_Ex_2

  • Add in the new series in C10 to C19
  • Put the new series on a secondary axis.
  • Change the new series (% net profit) to a dashed line
  • Make sure there is a legend at the top
  • Format the Revenue Axis as a number without decimals
  • Format the % Net Profit axis as a % with no decimals
  • Label the 2 vertical axis as Revenue and % Net Profit
  • Add vertical grid lines to make it easier to read the dates

Chart Ex 3

Out of the data in D10 to E34, create a column chart.

Set up the horizontal axis so that it includes the information in B10 to C34. The end result should look like this

Chart_Ex_3

To see the full course contents click here.

Back to: Intermediate Excel Course > Charting In Excel