Excel 2013 Charts and Graphs (MrExcel Library) by Bill Jelen

Author:Bill Jelen [Jelen, Bill]
Language: eng
Format: epub, azw3
Publisher: Pearson Education
Published: 2013-02-19T22:00:00+00:00

Figure 7.29. When the bullet value is in the caution zone, cell D5 calculates just enough of the caution color.

The formulas in row 5 always fill in enough color after the bullet to appropriately fill the whitespace from Figure 7.27.

When the bullet value is in the good zone, C5 and D5 are zero. E5 calculates enough of the good color to fill the whitespace to the right of the bullet. (See Figure 7.30.)

Figure 7.30. When the bullet value is in the good zone, cell E5 calculates just enough of the good color to fill to the right of the bullet.

To finish the main portion of the chart, make the chart shorter. Remove the Shape Outlines from all series. The chart now looks almost like a Bullet chart. The only thing missing is the quota marker.

The quota marker is really a Y-Error bar drawn from a single-point scatter series. To draw the quota at 47,000, use an X value of 47000 and a Y value of 1. Copy those two cells. Select the chart and Paste Special. Choose New Series and Categories (X Labels) in First Column. Click OK. (See Figure 7.31.)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.