Charts and Dashboards in Excel (full version)
Originally published: 17/11/2019 22:02
Last version published: 17/12/2019 22:04
Publication number: ELQ-24920-2
View all versions & Certificate

Charts and Dashboards in Excel (full version)

Explains the basics of designing professional charts in Excel with practical examples (full version)

Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel is an extremely powerful charting tool.

Charts is an effective means of transmitting data. Furthermore, a professionally designed chart immediately grabs reader's attention in a client pitch, business document or presentation.

However, one needs to be familiar with the 'tools of the trade' and to work on every chart element to make the chart look professional. In this publication we will look at the main techniques of designing professional business charts.

This file:

- defines key chart elements and explains how to edit them
- demonstrates how to deal with dates along the horizontal axis
- explains how to build dual-axes charts
- shows how to visually ‘transform’ the actual into forecast along the timeline
- describes how to create shaded areas on timeline charts

In addition to the above it includes six chart examples which you can use in your work or study.

The charts are accompanied by detailed step-by-step explanations on how to build them and interim chart versions.

Pictures and brief descriptions of those charts can be found in the short (free) version of this file:

There is a fun example which uses macros so make sure you have macros enabled when opening the file.

This Best Practice includes
1 Excel file, 1 PDF guide

Acquire business license for $20.00

Add to cart

Add to bookmarks


Further information

Explain how to create professional quality charts in Excel with practical examples

Financial models, presentations, business correspondence



  • Be the first to review this Downloadable Best Practice

    Write a review


More Best Practices from Andrei Okhlopkov

See all

Any questions on Charts And Dashboards In Excel (full Version)?

The user community and author are here to help. Go ahead!

0.0 / 5 (0 votes)

please wait...