How-to Put Percentage Labels on Top of a Stacked Column Chart

0
There are times when you are creating your Excel Dashboard Design that you desire something that does not come naturally with the Excel Tools as designed.  In those times you will need to come...

FUN Chart (Happy Mother’s Day!)

0
Recently I showed you one way that you can make Vertical Categories in an Excel Chart. (see How-to Make Categories for Vertical and Horizontal Axis in an Excel Chart) With that technique, you can create...
How-to Select an Excel Chart Series

How-to Select Data Series in an Excel Chart when they are Un-selectable?

6
When I first learned to make Excel charts, I was taught to select the chart and then select the data series with my mouse.  However, have you ever created a chart with so many...

Case Study: Executive Dashboard Chart Creation – Follow-up

0
The Problem In a recent post: “Case Study: Executive Dashboard Chart Creation” (https://www.exceldashboardtemplates.com/?p=1612) I presented some basic data that you may have in your company that you wish to add your executive dashboard. Here is the sample data: So...

How-to Make Categories for Vertical and Horizontal Axis in an Excel Chart

5
There are times in your Excel dashboard career that your boss will ask you to create an Excel Chart with category values for both your horizontal axis as well as the vertical axis.  As...

Make a Pie Chart Rating for Excel Dashboard Chart Templates

0
In a recent forum post, a dashboard user was asking how they can turn a decimal like 1.5 out of a 3.0 possible into a pie chart using Excel.  This specifics for the data...

How-to Add Custom Labels that Dynamically Change in Excel Charts

8
Have you ever wanted to have a different data point label in your Excel Chart than what is offered by the Standard Excel Dialog box choices? Well you can do that in Excel and not...

Case Study: Executive Dashboard Chart Creation

0
When building executive dasboards using Excel, you have to make the dashboard design choices that will assist your executives and the company in understanding the relationships of the data in a visually appealing and...

How-to Plot Building Wall UR Value in an Excel XY Scatter Chart

0
In an Excel Help Forum, an engineer wanted to know how to chart the following data: The data would need to be plotted like on the X and Y data points on the graph, however,...
Limitations for Excel Charts

Charting Specifications and Limits for Excel 2003, 2007 and 2010

5
Have you ever wondered how many data series you can actually add to an Excel chart?  Well there are limits.  Recently an Excel Client was having problems creating a chart with more than 34...