Home Line

# Line

### 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...

### 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...

### 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?