7. Advanced Chart Techniques

In This Chapter

Mixing Two Chart Types on a Single Chart

Moving Charts from One Worksheet to Another

Making Columns or Bars Float

Using a Rogue XY Series for Arbitrary Gridlines

Showing Several Charts on One Chart by Using a Rogue XY Series

Creating Bullet Charts in Excel 2013

Creating a Thermometer Chart

Creating a Benchmark Chart

Creating a Delta Chart

Next Steps

As the host of MrExcel.com, I get to see a lot of wild spreadsheets that people create. I have seen some amazing things come across my desk. This chapter covers some of the usual advanced charting tricks, and some unusual charts that you do not typically see in Excel. At the end of the chapter are a few examples of some charts that impressed me, so that ...

Get Excel® 2013 Charts and Graphs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial