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...]
How To Create An In Cell Bar Chart Using The REPT Function In Excel -Formula Friday
Hellow Excellers it is Friday again and time for #formulafriday where we have some Excel formula fun. Have you used the REPT function in Excel or ever used it?. It's a bit elusive so let's get it out of the shadows and bring into the limelight as see how we can use it!. Are you ever short of space on your Excel worksheet? Did you know that you can create in-cell bar charts?. You can do so using the REPT function in Excel and produce a very handy Excel chart like the one below. They are … [Read more...]
Formula Friday – Using Formulas To Add Custom Data Labels To Your Excel Chart
Happy Friday Excellers....today let's have a look at using a few types of formulas to add some really cool customised data labels to our Excel charts. Chart labels can really just help with giving clarity the message you are looking to communicate within your data to your audiences, so you may want to add even information to them, and get some added value without overcluttering your chart. The chart in our example shows April 2016 Sales Values for our 6 products we sell. Ok that is fair … [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...]
- 1
- 2
- 3
- …
- 8
- Next Page »
Recommended Excel Resources
