Quantcast
Home Tips and Tricks

Tips and Tricks

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

New Feature Excel Flash Fill Use it for Quick Data Retrieval and Formatting

0
Excel Flash Fill Every time a new version of Excel is released there are always new features that are hard to find and learn for those...

How-to Close the Gaps Between Chart Series in an Excel Stacked Clustered Column Chart

10
Many users like to create a chart that Excel doesn’t have as a chart type.  It is a combination of a clustered column and...

Excel Overlapping Columns on Second Axis for 3 Series

Stop Excel Overlapping Columns on Second Axis for 3 Series

8
We have learned how to Stop Excel Overlapping Columns in a few posts on the site.  A reader had a follow-up question that I...

How-to Make an Excel Vertical Likert Line Chart with Categories

26
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel.  The person...
Find And Replace from a List of Multiple Emails in Excel without VBA

Find And Replace from a List of Multiple Emails in Excel without VBA

2
Find And Replace from a List of Multiple Emails in Excel without VBA I had a recent request from a friend who needed to Find...

How-to Make an Excel Chart with 3 Different Column Widths (Bullet Chart Option 2)

2
In are recent post, I showed you how to create a Bullet Chart in Excel.  Pete, then sent me another way to create a...

Sum Across Excel Worksheets Tabs

How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)

1
Sum Excel Worksheets Technique Why haven't I known about this simple Excel technique before now? Maybe you were aware how you can easily Sum Excel Worksheets...

How-to Make a Basic Gantt Chart in an Excel Chart in 7 Easy Steps

6
Project Managers and Executives love Gantt Charts.  They also love Microsoft Excel, Charts and Graphs.  So it is a natural to consider how you...
Replace Numbers with Text for Excel Radar Chart Axis Values

Replace Numbers with Text in Excel Radar Chart Axis Values

6
Replace Numbers with Text in Excel Radar Chart Axis Values This is a cool Excel Trick that I just created based on a user request...
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