 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Media |
| Contact |
| Home |
 |
The tip in this show is from Charts and Graphs for Excel 2007.
(Click the book for more details) Watch the segment:
The key to making a number of innovative charts in Excel is to change the chart type of one or more of the chart series. The most common use of a combination chart is to show two series that are a different order of magnitude. To show Revenue in Millions and profit percentage on the same chart, follow these steps:
- Create a chart with both revenue and profit. You won’t be able to see profit.
- Choose Series Profit dropdown
- Move to the Secondary Y-axis in the Format Series dialog. The problem is that now the columns are directly on top of each other, making it impossible to see the smaller numbers.
- Change the chart type of the profit series from column to a line.
- Create a chart showing some data
- Type a new data range with X=Custom gridline locations and Y=0. Add this series to the chart. It completely ruins the first chart. That’s OK.
- Change the series to an XY chart.
- Make the markers be transparent
- Add an Error Bar extending to the right. This becomes the Gridline!
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.