Category: Excel charts

Show Excel Chart or Data in Dashboard With No Macros

In this Excel dashboard example, you can select “Chart” or “Chart Data” from a drop down list. Magically, with no macros in the workbook, the selected item appears on the worksheet.

select "Chart" or "Chart Data" from a drop down list
select “Chart” or “Chart Data” from a drop down list

With this technique, you can store your data and chart on a hidden sheet in the workbook, where no one can mess with the numbers. (Not that anyone would!)

Continue reading “Show Excel Chart or Data in Dashboard With No Macros”

Create Excel Chart With Shortcut Keys

To create a chart in Excel, you can select the chart data on the worksheet, then use the Ribbon commands to insert the chart. Or, for a quicker way, you can create an Excel chart with shortcut keys. See how to insert a chart, and change an Excel setting, so it inserts a specific chart type.

Continue reading “Create Excel Chart With Shortcut Keys”

Would You Approve This Excel Book Cover?

There is a list of Excel books on my Contextures website, and it hasn’t been updated recently. Today, I checked Amazon, to see what new and exciting Excel books had been released, so I could start adding them to the list.

New Excel Book

There’s a book – Excel 2010 Made Simple, by Abbott Katz — with a release date of May 31, 2011, from Apress, the publisher of my pivot table books.

Amazon lists the book as “not yet released”, but they show the cover, which you can see below.

Excel Book Cover wtih 3-D chart
Excel Book Cover wtih 3-D chart

Excel Charts Chapter

One of the chapters is on Excel charts, and the book blurb promises that you’ll learn “How to create colorful, meaningful charts”.

I hope the cover chart was selected by someone in the Apress marketing department, and not the author!

Missing Books

I’ll be updating the list of Excel books over the next few weeks, so if you know of any recent books that are missing from the list, please let me know, so I can include them. Thanks!

Make a Simple Pie Chart

And if you do need to make a pie chart in Excel, for a business report, or for the cover of your next book, keep it simple!

This video shows how to make a basic pie chart in Excel, then add formatting, labels, and other features. Use your Excel charting powers for good, not evil!

Excel Chart Links

If you want to learn more about Excel chart, but not the 3-D rainbow-coloured kind, check out the tutorials at the following links:

Box Plot Chart (Box and Whisker)

Line-Column Chart 2 Axes

Cluster Stack Chart

Pie Charts

Waterfall Chart

In-Cell Charts

____________

Simple Project Planning With Excel Gantt Chart

If you’re building a new city, or plotting world domination, you’ll need a powerful project management tool, such as Microsoft Project.

For smaller projects, you can list your tasks in Excel, and create a Gantt chart, to show the timeline. Here’s how you can do simple project planning with Excel Gantt chart – watch the video and there are written steps too.

Continue reading “Simple Project Planning With Excel Gantt Chart”