User Friendly
2.8K views | +5 today
Your new post is loading...
Your new post is loading...
Scooped by Alesandra Blakeston
Scoop.it!

Yamazumi charts

Yamazumi charts | User Friendly | Scoop.it
The Yamazumi chart - also known as the operator line balance chart - is a load chart that breaks down the individual work tasks in a process, detailing the time they take. Obviously, it's used in l...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Coin chart in Excel 2010

Coin chart in Excel 2010 | User Friendly | Scoop.it
One thing I haven't shown you (yet) is a chart showing spend over time like the one below. This chart uses a simple coin edge graphic to show the amount spent each month.
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Using animation with charts

Using animation with charts | User Friendly | Scoop.it
Recently I posted a blog on how to simplify charts so that the key message came across simply by looking at the chart.  I got a few messages after the post from colleagues saying that while the ove...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Less is more

Less is more | User Friendly | Scoop.it
In the business world I come across some really awful charts.  Take for example the one below (I've changed the categories and title to protect the innocent!): What exactly is the message behind th...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Create a series of traffic light charts

Create a series of traffic light charts | User Friendly | Scoop.it

The idea would be to create a series of traffic lights that show a warning light (orange) when the stock level is the same as the reorder level, a danger light (red) when the stock is lower than the...

more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Create a step chart

Create a step chart | User Friendly | Scoop.it
If you don't know what a step chart looks like, it looks like the picture below.  Step charts are a specialized form of line charts that use only vertical and horizontal lines to connect the data p...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

How to create a double lollipop chart

How to create a double lollipop chart | User Friendly | Scoop.it
Visually great charts are always welcome in my inbox, so when a friend forwarded a link to me showing a tutorial on how to create a double lollipop chart, I was intrigued.  A double lollipop chart ...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Non-linear training using Action buttons and Tabs in PowerPoint

Non-linear training using Action buttons and Tabs in PowerPoint | User Friendly | Scoop.it
So I saw a great post last week on eLearningDesigner.com showing images of a Tabbed Training presentation they made for a client.  Put simply, it inspired me to create my own!  It turns out it's ac...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Highlighting the difference between actual and target

Highlighting the difference between actual and target | User Friendly | Scoop.it
Sometimes it is important to know the performance against a target.  There are of course lots of ways of doing this, my favourite being bullet charts.   That being said, you can also show this with...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

5 Exciting (and awesome) line charts in PowerPoint

5 Exciting (and awesome) line charts in PowerPoint | User Friendly | Scoop.it
I'm always on the lookout for new ways to show data visually.  When you can see the problem data at a glance, it's easier to to tell your story and convince people to help you / invest / solve the ...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

A to Z of awesome Excel

A to Z of awesome Excel | User Friendly | Scoop.it
I've been posting for a while now, and it has to be said, my most popular posts are usually the ones I do on Excel. Since I have now got over 300 posts on this blog and 50+ on Excel alone, I though...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Combination Line & Pie Chart

Combination Line & Pie Chart | User Friendly | Scoop.it
Way back in February of 2013, I published a how to guide on how to create a world map pie chart using vba and Excel. Although I wrote the how to, the original work was of course done by Andy Pope. ...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Conditional formatting intersect area of line charts

Conditional formatting intersect area of line charts | User Friendly | Scoop.it
So late last week a colleague came into my office and started doodling on my whiteboard.  He wanted to know if I had a template for showing positive and negative intersect areas of line charts.  So...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Animate a single series in a chart

Animate a single series in a chart | User Friendly | Scoop.it
Last week I posted a simple video showing a couple of graphs that had a single (or couple) of series animated for emphasis.  I thought this week I would post the how to!  It's actually very simple....
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Freebie: Open Blue template in Keynote and PowerPoint

Freebie: Open Blue template in Keynote and PowerPoint | User Friendly | Scoop.it
It was my birthday last week, a fact I celebrated by going out and splurging on a macbook pro with retina display and a huge amount of memory! While exploring, it occurred to me that I'd never offe...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Free Dynamic Navigation PowerPoint Template

Free Dynamic Navigation PowerPoint Template | User Friendly | Scoop.it
I took the principle of having navigation at the top, bottom, left and right and added hyperlinks to each of the buttons. Feel free to download my example based on work by www.gmark.co
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Using Powerpoint like Prezi

Using Powerpoint like Prezi | User Friendly | Scoop.it
In the video you will see a PowerPoint presentation consisting of 10 slides. The movement is created with very simple transitions between the slides called PUSH transitions.
You can use this ef...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Create a block bar doughnut chart

Create a block bar doughnut chart | User Friendly | Scoop.it
While not a big fan of pie charts and doughnut charts, when I am sent a challenge, I like to follow through.  The challenge was to create a doughnut chart in Excel for use on an infographic with bl...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Broken column chart with a stacked bar chart

Broken column chart with a stacked bar chart | User Friendly | Scoop.it
A long time ago now, I wrote a "how to" guide for creating a broken column / bar chart.  Since then I have been inundated with requests for variations on this chart.  The one I get the most often i...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Network relationship chart

I'm a big fan of anyone who can display data in a visual way.  Well today, rather than displaying my own work or giving a "how to" guide, I thought I'd display work from Chandoo.org - one of the be...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Highlight a time period on a line chart

Highlight a time period on a line chart | User Friendly | Scoop.it
So today I thought I would post the "how to" for the third in the series of line charts I posted a while back. Let's imagine that you want to highlight a poor period during your year. This chart is...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Minimum and Maximum Markers

Minimum and Maximum Markers | User Friendly | Scoop.it
Last week I posted a series of 5 line charts in PowerPoint that were visual. I promised at the time that I would post this week the how to for each of the charts.  This post is the first of these: ...
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Trust me

Trust me | User Friendly | Scoop.it
Found this great SlideShare in my feed this morning.  Do you have trust?  How do you get noticed? +Alesandra Blakeston
more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Avoid These 10 Biggest Office Distractions to Get Work Done

What is the one goal you have in mind when entering the office in the morning? To get work done. What is often the last thing you are able to finish? The thing…
Alesandra Blakeston's insight:

Great slideshare by Weedone.com

 

Which is your biggest office distraction?

more...
No comment yet.
Scooped by Alesandra Blakeston
Scoop.it!

Create line charts with confidence bands

Create line charts with confidence bands | User Friendly | Scoop.it
Creating confidence bars in Excel is relatively easy.  First create your line chart.  Then with the series selected, click on Chart Tools > Layout > Error bars > More error bar options.  I...
more...
No comment yet.