Create Excel Charts
Do you want to start or improve your use of charts in Excel? You’ve come to the right place! Here you will find resources that will take you from starting out to expert level in your creation of Excel charts. Select the level/area you want to learn more about to get started.
Beginning with Excel charts
- Never created a chart in Excel and want to learn the basics? Start with this article and video by Excel MVP Leila Gharani.
- Have an Excel chart you or someone else created and you want to copy it so you can use the same formatting with different data? Here’s how to do that from Excel MVP Jon Peltier.
Take your Excel charting skills to the next level
- Free ecourse on creating Presentation-Ready Excel Charts that are Easy to Update and Re-use
- Free Calculator download to create non-standard charts
- Paid ecourse: Excel Chart Skills 501: Quickly learn expert-level Excel techniques so you can create presentation-ready charts that are easy to update and re-use without programming, add-ins, or web tools
- Paid ecourse: After the Analysis: communicating results from Excel in PowerPoint
Add-ins/Web tools for Excel charts
- Jon Peltier’s Excel chart add-in at https://peltiertech.com/Utility30/
When you are considering using an add-in for Excel, always remember to check with your IT department to make sure it approved and allowed to be installed on a corporate computer. Also make sure that the charts it creates will be in the current chart format so others can use the files you create.
If you are considering using a web tool to create charts, be careful. Your organization likely has a data privacy & security policy that prohibits putting confidential data on external websites. You don’t want to end up violating an important intellectual property policy by using one of these sites.
Recent articles on Excel Charts
In my Twitter feed I saw a number of well respected data visualization experts liking a recent article by RJ Andrews for the Data Visualization Society. In it he talks about the issue of starting the axis of a graph at a value other than zero. This is a common topic...
If you create a graph in Excel, how do you get the colors to match the organization’s PowerPoint template? The two most common approaches are: 1) spend time typing in the RGB values for the correct colors into Excel for every graph, or 2) ignore the desire to make the...
When you want to compare values to a standard, such as comparing output in various production plants to the goal, a dashed line on a column graph is a good visual to use. The dashed line runs across the graph and it is easy to see if each column is above or below the...