Charting- covered in Intermediate course

Below a listing of what you would have learnt in the Intermediate course which feeds into this Advanced course.

Please check that you are comfortable with these items.

  • Excel Charting introduction
  • Create a chart
  • Align chart to the grid lines
  • Chart doesn’t look right? First thing to try
  • Customise the chart title, area, legend and more
  • Vertical Axis- force the scale, reverse the order, labels and more
  • Horizontal Axis- dates vs text, reverse order, show all labels
  • Series- overlapping, big and small series, gaps
  • Add more series to the chart- 3 ways
  • Show big and small numbers on the same chart (and be able to see them)
  • Show months, quarters AND years on the chart axis
  • Bar Charts
  • Pie Charts
  • Area Charts
  • Radar Charts (to compare projects?)
     
Back to: Advanced Excel Course > Charting In Excel