Why? Because they can represent data that falls to the left of or below a baseline-as is appropriate for negative numbers. If negative numbers are expected, then column or bar charts are a much more appropriate choice. Pie charts, by their nature, are not well-suited for displaying negative numbers. Granted, they are negative portions, but they are portions nonetheless. After all, pie charts represent portions of a whole-yet by filtering or adjusting totals, portions of the whole are being removed. Of course, all this being said, one would have to wonder if a pie chart is the appropriate chart for representing this type of data in the first place. This will cause those values to be ignored in the chart created by Excel. If your data is conducive to filtering, you could also set up a filter so that negative values are filtered out. In this case, the value to be charted is set to zero if the sum is less than zero, or it reflects the actual total if the sum is zero or above. Instead of using a standard SUM formula for the values to be charted, you could use a formula such as the following: Thus, pie charts are often created based on the result of some sort of formula, such as the sum of values in a column the sums of each column are the basis for the pie chart. Each value within the series represents a portion of the whole. Normally, people create pie charts based on a simple set of values. Drag the Pie Explosion slider to increase the separation, or. To more precisely control the expansion, follow these steps: Right-click the pie chart, then click Format Data Series. ![]() ![]() You may, however, prefer to have the negative values charted as if they were zero-to not have a slice of the pie. The quickest way to pull all of the slices out of a pie chart is to click the pie chart and then drag away from the center of the chart. ![]() If you create a pie chart, Excel charts negative values as if they were positive (in other words, it uses the absolute value). ![]() Excel allows you to easily create charts based on the data in a worksheet.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |