Charts and Dashboards in Excel (full version)
Originally published: 17/11/2019 22:02
Last version published: 18/09/2023 08:50
Publication number: ELQ-24920-3
View all versions & Certificate
certified

Charts and Dashboards in Excel (full version)

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

Description
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: https://www.eloquens.com/tool/GYglcgJv/andrei-okhlopkov/charts-and-dashboards-in-excel-short-versionThere 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

Discuss

Further information

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

Financial models, presentations, business correspondence

None


5.0 / 5 (1 votes)

please wait...