Tag Archives: charts

Microsoft Excel – using slicers with charts

Posted on November 3, 2022 by jdonbavand

A slicer allows us to look at different filters of a Pivot table or a chart. If I have charted data in Excel, but want to see the information for values in a field not in the chart I can … Continue reading →

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Excel – putting two or more charts on same sheet

Posted on August 19, 2020 by jdonbavand

To put two or more charts on to a single chart sheet: Click an empty cell, and press [F11] (or Fn + F11 depending on your laptop. Change the default chart name to Two Chart Sheet (or some other suitable … Continue reading →

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , , | Leave a comment

Microsoft Office – creating chart showing only weekdays

Posted on January 8, 2020 by jdonbavand

I have some Excel data that only shows data for week days as I do not work weekends. However, when I came to chart it, it put the weekend dates in, showing blanks. This wasn’t what I wanted. Right-click on … Continue reading →

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Microsoft Office 2013, Microsoft Office 2016, Microsoft Office 365, Microsoft PowerPoint 2013, Microsoft PowerPoint 2016, Microsoft Word 2013, Microsoft Word 2016 | Tagged , , | Leave a comment

Microsoft Excel – using series from more than one worksheet in a chart

Posted on November 30, 2017 by jdonbavand

Sometimes you may create a chart in Excel and then want to add data from another worksheet. To add in extra data, on the Chart Tools Design tab, in the Data group, click Select Data. At the left under Legend … Continue reading →

Posted in Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Office – labels for stacked column totals

Posted on August 5, 2016 by jdonbavand

If you create a stacked column chart it is easy enough to show data labels for the individual parts of the stacked column but not so obvious how to create a label just showing the column total. To do so, … Continue reading →

Posted in Microsoft Office 2007 and 2010, Microsoft Office 2013, Microsoft Office 2016, Uncategorized | Tagged , , , , , | Leave a comment

Creating a secondary vertical axis for charts in Microsoft Office 2007 or Office 2010

Posted on July 1, 2012 by jdonbavand

Sometimes when you chart data, you are not really comparing like with like, and may want two vertical axes, for example if you are comparing temperature with rainfall. Climate in Buenos Aires Month Temperature (deg C) Rainfall January 30 119 … Continue reading →

Posted in Microsoft Excel, Microsoft Office 2007 and 2010, Microsoft PowerPoint | Tagged , , , | Leave a comment

Add animation to a Microsoft PowerPoint chart

Posted on June 3, 2012 by jdonbavand

You may have created a Microsoft PowerPoint chart but want the data for each year to be displayed separately, so you can talk about one set of figures before introducing the next. Locate the slide in Normal view. Charts can … Continue reading →

Posted in Microsoft PowerPoint | Tagged , , | Leave a comment