Create an Excel Timeline Chart to Manage Your Projects and Events

Charts , Dashboards , Excel , Excel Project Management , Project Management , Time Management , Time Management and Personal Productivity

Excel timeline charts are a great tool in any professional’s toolkit. You can insert Excel timelines in your Excel workbooks where you manage projects, show resources and expenses, schedule marketing events, etc. They make communication and detection of conflicts much easier. In the following article you’ll learn how to make a static timeline. In the […]

Continue reading

Adding a Data Series to an Excel Chart

Charts , Dashboards , Excel , Shortcuts , Tips

It happens to everyone, it’s the reason Excel was created – the data changes and your Excel chart must change. And it’s not just the values of a specific data point in a data series that change, sometimes an entirely new data series must be added.There are three ways to add data to an existing […]

Continue reading

Quickly Change Excel Chart Styles and Themes

Charts , Dashboards , Excel , Shortcuts , Tips

If you’ve been creating charts in Excel 2007 or a newer version for very long you know how easy it is to format a chart using one of the predefined formats. For a worksheet, just select the Page Layout tab then at the far left on the Ribbon click the Themes drop-down and mouse over […]

Continue reading

Undoing All or Part of an Excel Chart’s Original Theme

Charts , Dashboards , Excel

It’s easy to spend a lot of time formatting a chart, but if you’re like me you try different things and in the process you want to go backward and forward testing different changes. You may even want to go back to the original theme or part of the original theme. Here’s how to go […]

Continue reading

Aligning Excel Charts and Objects on a Worksheet

Charts , Dashboards , Excel , Shortcuts , Tips

If you want professional looking dashboards you need to make sure that charts and objects you draw align with each other and with cell contents. Your charts and objects should have corners aligned and most objects should be the same size. Even if you have hidden the grid lines it’s a snap to get things […]

Continue reading

Creating an Actual vs Target Chart in Excel using Floating Markers

Analysis , Charts , Dashboards , Excel , Metrics and Measures

Almost everyone in business has heard the maxim, “What you measure is what gets managed.” We know that measuring is important, but measuring is only the start. If you are going to improve what you are measuring you need targets. And before you start changing you need to know how far off the target you […]

Continue reading

Create Excel Charts and Dashboards with Color Alerts for Actual and Target Values

Analysis , Charts , Dashboards , Excel , Metrics and Measures

Your Excel charts should alert you with color differences between actual and target values. Here’s a quick way to create an Excel chart that shows the color coded difference. In this example the Delta, or difference, is a column containing the calculation, Delta = Actual – Target The chart is created from the month labels […]

Continue reading

Hiding Worksheet Data Used in Excel Charts and Dashboards

Charts , Dashboards , Excel , Tips

Recently an associate called me with an Excel 2010 problem. She was asked to create an elegant worksheet that pulled data in from an external database, did calculations, and then charted the results as well as creating a columnar report. Sounds pretty easy so far. The problem she ran into was that when she hid […]

Continue reading

Show Excel Pie Chart Details with an Exploded Bar Chart

Charts , Dashboards , Excel

Show the details in a pie chart by exploding sections into a bar chart. To get the big picture of how a total is distributed, for examples total sales by country or unit volumes by region, most executives want to see a pie chart. This is one of the few things a pie chart might […]

Continue reading

Telling the Story Behind Your Data – Awesome Videos with Hans Rosling

Charts , Communication Skills , Dashboards , Excel , Metrics and Measures , Presentation Skills

If you want to make an impact, you have to put a gripping story behind your data. You can have earth shattering data, incredible statistical analysis, and even beautiful charts and visuals, but if you can’t put a gripping story behind it your audience won’t remember and won’t act. If you want to see how […]

Continue reading