Tag: XY Scatter
How-to Create a Time Data Series Step Chart in Excel
In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is...
How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard
Have you ever wanted to create a graph but then let users dynamically change the Excel chart type with a drop down pick list? ...
How-to Add Centered Labels Above an Excel Clustered Stacked Column Chart
I am currently working on a project in L.A. and a business analyst at the client site was looking for a chart to present...
How-to Create a New York Times Tiger Woods Chart in Excel
In a past article, I posted 2 different ways to make a chart that appeared in the New York Times. Here is the chart...
How-to Make an Excel Vertical Likert Line Chart with Categories
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel. The person...
How-to Make and Add Custom Markers in Excel Dashboard Charts
When is a picture worth a thousand words? Definitely when you use custom markers in your Excel Charts.
This will make your Excel Dashboard Charts...
How-to Plot Building Wall UR Value in an Excel XY Scatter Chart
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...
How-to Draw a Vertical and Horizontal Line that Intersect in an Excel Chart
Recently a user in the Mr. Excel Forum a member wanted to know how they could make an Excel Chart where one Metric was...
Tiger Woods PGA Tour and Major Championship Chart
I am a fan of the PGA and Tiger Woods. So I was really excited when I saw this post from Paresh Shah of...
