Hello, Excellers. Want to know how to create a Self Expanding Chart. Video tutorials are a great way to learn Excel. If you want to learn Excel you then I invite you to subscribe to my YouTube channels for lots of Tips and Tutorials. Here is a free tutorial on creating self-expanding charts. It is one tip that readers liked very much so I have recorded a video tutorial. This is a simple and effective this technique is to add new data to Excel charts … [Read more...]
Create A Self Expanding Chart In Excel
by Barbara

Hello Excellers, welcome back to another Excel tip today. I will show you how to create a self-expanding chart. This tip is also a YouTube Video. Why not check it out in the link below. So, it is really easy to create a self-expanding chart in Excel. Is it?. YES!. Normally a chart is set up to only display what is currently on the datasheet. But, by a few tweaks and Excel magic, we can set up a chart differently. We can allow a chart to automatically accommodate new data as it is … [Read more...]
Sizzling Hot Excel Dashboard Course.
by Barbara

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
by Barbara

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
by Barbara

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 »