charting

Episode 373 – Charting Magnitude

               

Sometimes you want a chart to show two different kinds of data – for example, revenue, and gross profit percentage. If you create such a chart, the size of the revenue bars makes it impossible to see the detail in the profit percentage bars. The trick is to plot one of the series along a(…)

Episode 349 – Chart Data

               

In Episode 349, learn a cool way to add new data to an existing chart. My book usually shows the drag and drop method to add data, but in Episode 349, you can learn how to drag the selection handle to add or remove data from a chart. This blog is the video podcast companion(…)

Learn Excel from MrExcel