Sunday, August 30, 2015 – Permalink –
Too Many Slices
More data than the pie will hold
A pie chart displays the per cent of the whole is represented by the component elements. Four salesmen, four slices of pie.
The problem arises when there are 10 or so components that vary in size. The labels begin to overlap and the chart is difficult to read:
One suggestion that Chris Weber offers is to rearrange the order of the slices:
The article uses MS Graph in Access, but the techniques are applicable in all the other applications that can use graphs.
Easy as Pie. . .
"Chris Weber provides you with a generic method to control the data for pie charts that are actually readable."
(A downloadable example file is also provided
See all Topics excel
<Doug Klippert@ 3:49 AM
Comments: Post a Comment