Posts Tagged 'Excel charts'

Excel Cumulative Sum - easy way to calculate running total

This short tutorial shows how a usual Excel Sum formula with a clever use of absolute and relative cell references can quickly calculate a running total in your worksheet. Continue reading

How to create a histogram in Excel 2010, 2013 and 2016

While everyone knows how easy it is to create a chart in Excel, making a histogram usually raises a bunch of questions. In fact, in the recent versions of Excel 2010, Excel 2013, and Excel 2016, creating a histogram is a matter of minutes and can be done in a variety of ways. Continue reading

Automatically create 3D bubble charts in Excel with the 5dchart Add-in

From this article you'll learn about the 5dchart add-in. It's a flexible and easy-to-use Excel tool that makes creating 3D bubble charts and scatter plots fun and easy. Continue reading

How to create a bar graph in Excel

In this tutorial, you will learn how to make a bar graph in Excel, how to have values sorted automatically descending or ascending, how to create a bar chart in Excel with negative values, how to change the bar width and colors, and much more. Continue reading

How to create a pie chart in Excel

In this Excel pie chart tutorial, you will learn how to make a pie chart in Excel, add or remove the legend, label your pie graph, show percentages, explode or rotate a pie chart, and much more. Continue reading

Make a chart in Excel from two or more different sheets

The tutorial demonstrates how to make charts in Excel from multiple sheets, and how to customize and edit such graphs. Continue reading

How to create a chart (graph) in Excel and save it as template

The tutorial explains the Excel charts basics and provides the detailed guidance on how tou will also learn how to combine two chart types, save a graph as chart template, change the default chart type, resize and move the graph. Continue reading

How to create waterfall chart in Excel (bridge chart)

This article looks at creating basic graphs and at a special chart type – the Waterfall chart in Excel. Read on to find out what a waterfall chart is and when you can find it useful. You'll learn what tools can help you with creating waterfall charts in Excel 2016, 2013. Continue reading

How to rotate charts in Excel - rotate bar, column, pie and line charts

This post describes how to rotate a chart in Excel 2010-2013. You'll learn different ways to spin bar, column, pie and line charts including their 3-D variations. Besides, you'll see how to reverse the plotting order of values, categories, series and legend. Those who often print graphs and charts will read how to adjust the sheet orientation for printing. Continue reading

What are Excel sparklines and how to insert them to analyze your data

Do you know what Excel sparklines are and how helpful they can be? Read this article and find the answers to these questions. You will learn how to insert sparklines in Excel 2010 – 2013; change their type, style and color; highlight the most important points and remove sparklines from cells. Continue reading

How to make a Gantt chart in Excel 2010, 2013 and Excel 2016

See how you can quickly make a simple Gantt chart in Excel, where you can download advanced Excel Gantt chart templates or utilize the online Project Management Gantt Chart generator. Continue reading

Working with Maps in Excel 2013

Yes, now it is possible to work with nice charts that have Maps in Excel 2013. The latest version comes with the Power View. It is an extremely powerful reporting tool. Sometimes we need to get sales reports and we want to identify regions and patterns of sales related to the customers. In this article you will learn how to create cool reports in Excel. We will show countries, cities and specific geographical points. This article is for newbies who want to learn about this exciting area. Continue reading

How to add titles to Excel charts

If you don’t want to get lost in all the charts in your Excel worksheet, then spend some minutes to read this article and learn how to add a chart title in Excel 2013 and have it dynamically updated. I’ll also show you how to add descriptive titles to the axes or remove a chart or axis title from a chart. There’s nothing to it! :) Continue reading

How to save Excel chart as image, copy or export it to Word & PowerPoint

In this article you will learn 4 quick ways to save your Excel chart as an image (.jpg, .png, bmp. etc.), copy or export it to another file such as a Word document or PowerPoint presentation. Continue reading

How to rotate Excel charts or worksheets: quick tip

Certain worksheets or charts may look much better if you change their orientation. So in today’s how-to article we’ll have a look at how to rotate Excel table or chart. Continue reading

Microsoft Excel Charts: Tips, Tricks and Techniques

Some tips, tricks and techniques for better looking charts in Microsoft Excel. Continue reading

Interactive elements in Excel with Spin Buttons and Scroll Bars

Whenever your user has a discrete number of choices to make for inputting data into an Excel worksheet you can save time by automating how they enter this data. You can do this in a number of ways and one of them is to use a spin button or a scroll bar to do the work... Continue reading

Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard