Quantcast

Protecting Your Excel Charts and Dashboards with Array Formulas

2
Has this ever happened to you? You have sent your Excel Dashboard to your executive team or perhaps you have your spreadsheet on a shared...
Grouping Pivot Table Data in Excel

Advanced Excel Summation Techniques Using Pivot Table

0
There are many ways to Sum data in Excel.  But when you have lots and lots of data, then you will want to learn...

How-to Make an Excel Area Chart Cliff (Fiscal Cliff Edition)

0
So all the US news agencies keep talking about the Fiscal Cliff.  This reminded me of a problem that many people have when making...

How-to Make an Excel Stacked Column Pivot Chart with a Secondary Axis

0
In this previous post: Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second Axis I had a fan question - How...
Copy an Excel Chart on Same Worksheet Keeps Same Data Reference Final Copied Charts

How-to Copy a Chart and Change the Data Series Range References

0
Last week we learned how to copy a chart in Excel quickly and have it reference a new chart data range on the same...

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

How-to Concatenate Excel Column or Row Data Using Google Docs

0
Yesterday I demonstrated how to find and replace a hard return in an Excel spreadsheet.  I presented the last topic before this one so...

Group Column Chart with Lines for Excel Dashboard Presentations

1
Yesterday a user in the MrExcel.com Forums asked how he could make a Column Chart in Excel and then Group those Columns with a...

How-to Group and Categorize Excel Chart Legend Entries

2
If you have a chart with Legends, then you should check out this tutorial. Recently when working on a solution for a fan, I noticed...
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...
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