Excel Chart Articles
-
Matching Excel charts to a PowerPoint color scheme; Issue #434 March 5 2019
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 colors match because of the……
-
Comparing only one value to a standard; Issue #432 February 5 2019
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 goal.……
-
Bar charts with long category labels; Issue #428 November 27 2018
How do we create graphs with category labels that contain a lot of text? If you are comparing values to each other, a column graph can get tricky since Excel and PowerPoint will turn the text at an angle and cut off labels that are really long. This makes it very hard for the audience……
-
Graph using Excel Data Bars; Issue #420 August 7, 2018
Most business professionals are familiar with creating graphs in Excel using the powerful built-in graph features. Today I want to show another feature of Excel that can be used to create a bar graph quickly in Excel. It has limitations but can be particularly useful when you want to create multiple bar graphs of related……