Quantcast

How-to Make an Excel PickList Chart for Multi Years by Month

6
Here is my response to the recent Friday Challenge on Creating a Chart for Multi Years by Month. You can read more about the original...

How-to Draw a Straight Line with Excel Shapes

4
Have you ever tried to draw a straight line in Excel only to get frustrated? It can be so Frustrating :) to be off by...

Friday Challenge Answers – The Boss Says…

2
I received some great responses from lots of fans.  Thank you so much for all your great comments.  I agree with most and my...

How-to Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart

6
Sales executives are always pushing their sales teams.  They typically do this by setting sales quota’s for their salespeople.  Quotas are thresholds or minimum...

How-to Show Gaps in a Line Chart When Using the Excel NA() Function

4
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart.  In essence, he wanted to...
Add a Target Line to a Clustered Stacked Column Chart

How-to Add Lines in an Excel Clustered Stacked Column Chart

2
I have posted several Excel chart samples related to Clustered Stacked Column Charts. In case you missed them, you can check them out here:   Excel...
Final Stacked Column Pivot Chart with a Grand Total Line

How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart

8
Today I answer a viewer question. "How do I add a cumulative grand total amount as a line above a stacked column pivot chart...

How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard

4
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 Connect Gaps in a Line Chart in Excel

5
When you are build your Excel Dashboard Template charts, you may find that some of your data is not complete.  For instance, you may...

How-to Add a Line to an Excel Chart Data Table and Not to the...

8
Many people making Excel charts love to add a Chart Data Table to their graph.  However, the Excel Data Tables are not very flexible...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link