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...]
How To Create An In Cell Bar Chart Using The REPT Function In Excel -Formula Friday
by Barbara

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

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...]
- 1
- 2
- 3
- …
- 8
- Next Page »