I really do not recommend too many Excel products or courses (as you can probably see from my site), and I have a few rules that I apply when paying for either an Excel product or a Course for myself. That is why I am going to take the unusual step and recommend this Dashboard Course by Mynda Treacy at My Online Training Hub.Com A few rules I go by (just to let you know) before would recommend any online products to anyone. 1. I always read the reviews first, as many as I can find, I 'm spending … [Read more...]
Create A Micro Chart From A Normal Excel Chart
Here is a really great way of displaying a micro (or easily resizeable) chart in Excel. It makes use of the Camera Tool. Sometimes hidden, Camera is a tool that is really useful but not that many Excel users either exists or see how they could use it productively. The Excel Camera tool lets you take a live picture of a range cells (a chart for example) and everytime that range of cells change the picture updates dynamically as well to reflect these exact changes. That could be useful … [Read more...]
Re-Order Data Series In An Excel 2013 Chart
When you create a chart in Excel, you may find that you need to change the order of the way the data series is displayed in your chart. For examaple you may have a Minim, Maximum and Average Sales price in your chart data which you want to display in the order Average, Maximum then minimum. You could change the order of the data in your data source in your work sheet range which would automatically change the order of the chart data display. If you do not want to amend your source data, you … [Read more...]
Excel Charting Tip -How To Create a High Low Close Chart but not for Stocks!
I do not see these charts being used much - except for stock market ones but high low close charts are really useful where you have three data series like high, low and average data to show. The average data series replaces the closing that appears in stock charts. Here is a great example. I have some temperature data for Ireland from 1962 to 1991. I have the highest, lowest and average monthly temperatures for that period. To create the chart Select your data - including all of … [Read more...]
Excel Charting Tip- How To Create A Sales Funnel Or Pipeline Chart
You can download the file for this Excel Tip here. [ddownload id="8204"] See The Video. You can watch the video for this Excel tip here. Sales Funnel or Pipeline charts are increasingly used in Business Intelligence packages and are part of data visualisation on dashboards on a regular basis by most businesses. Even though they used regularly they are not actually pre built into Microsoft Excel. So how can we create one if we use Excel?. With a bit of creativity and the use … [Read more...]
- 1
- 2
- 3
- …
- 7
- Next Page »
Recommended Excel Resources
