fbpx
Search
Close this search box.

All articles with 'sparklines' Tag

Win Loss Chart from a Series of Win, Loss Data

Published on Jun 15, 2011 in Charts and Graphs
Win Loss Chart from a Series of Win, Loss Data

Last week, we learned how to create win-loss charts in Excel. In the comments, Dan said,

“Incidentally, the fastest way to do this would be using SFE, just reflect your data with 1 for a win, – 1 for a loss. There’s even an option to automatically invert negative numbers.”

Of course, we can use the beautiful Sparklines for Excel addin to do this and several other charts. But if you just have a series of Wins and Losses, like below, you can use a column chart to create win loss charts too.

Today, we will learn how to create a win loss chart from a set of win, loss data in Excel.

Continue »

How to create a Win-Loss Chart in Excel? [Tutorial & Template]

Published on Jun 9, 2011 in Charts and Graphs
How to create a Win-Loss Chart in Excel? [Tutorial & Template]

Win Loss Charts are an interesting way to show a range of outcomes. Lets say, you have data like this:

win, win, win, loss, loss, win, win, loss, loss, win

The Win Loss chart would look like this:

Win Loss Charts in Excel - Template & Tutorial

Today, we will learn, how to create Win Loss Charts in Excel.

We will learn how to create Win Loss charts using Conditional Formatting and using In-cell Charts.

Continue »

Health-care Dashboard in Excel [Dashboard Week]

Published on Mar 22, 2011 in Charts and Graphs
Health-care Dashboard in Excel [Dashboard Week]

As part of Dashboard Week, in this post, we will take a look at Health-care Dashboard prepared and shared by Alberto. He put together an excellent dashboard to visualize hospital performance and understand what is going on. Read this post to understand how this dashboard is made, watch a tutorial video & download example workbook.

Thank you Alberto for sharing the file & helping us learn.

Continue »

Introducing PHD Sparkline Maker – Dead Simple way to Create Excel Sparklines

Published on Mar 22, 2010 in Charts and Graphs
Introducing PHD Sparkline Maker – Dead Simple way to Create Excel Sparklines

Sparkline or Microchart is a tiny little chart that you can place on dashboards, reports or presentations to provide rich visualization without loosing much space. In excel 2010, MS introduced a beautiful feature for creating sparklines from data in spreadsheets. For earlier versions of Excel (that is 2007 and before) there is no native support […]

Continue »

Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster

Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster

Sachin Tendulkar is undoubtedly the best cricketers to play One Day International Cricket. He is a source of inspiration and joy for me and many others. So, naturally I was jumping with joy when I heard that he scored the highest ever runs in a single match on 24th of Feb. He scored 200 runs […]

Continue »

Best Sales Dashboards, as Voted by You [Visualization Challenge #2 – Winners]

Published on Jan 18, 2010 in Charts and Graphs
Best Sales Dashboards, as Voted by You [Visualization Challenge #2 – Winners]

Finally, our second visualization challenge comes to an end. We got a winner. Background about Zoho Reports Visualization Challenge: (skip this section if you know what I am going to say) Back in November, 2009, I have asked the readers to come up with best possible ways to visualize a set of fictitious sales data. […]

Continue »

Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations

Published on Jan 4, 2010 in Charts and Graphs, Featured
Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations

Sales reports and dashboards are very common in any company. There are several ways in which you can visualize sales data to understand the trends and sales performance. So in November, I have asked you to visualize sales data using sample data. The visualization challenge #2, sponsored by Zoho Reports generated a huge buzz around the community and fetched 32 incredible entries. The response was so overwhelming that it took me almost 24 hours to write this post. Thanks everyone for participating and making this a huge learning experience for everyone. Personally I have learned several useful dashboard and charting tricks. I will be sharing some of these lessons with all of you in the coming weeks.

Continue »

Microcharting in Excel – 7 Alternatives Reviewed

Published on Sep 5, 2008 in All Time Hits, Charts and Graphs, Featured, ideas, Learn Excel
Microcharting in Excel – 7 Alternatives Reviewed

With each passing day the amount of information contained in a single spreadsheet, slide, document is growing. Thanks to demanding bosses, clients and colleagues, we are now supposed to provide all the relevant information in as much less space as possible. This is where micro charting or light weight data exploration has become a rage. […]

Continue »