|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 31st, 2009, 07:00 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
4 graphs / one sheet / cramming for space
Hi,
I have four pie charts that are displayed on one 8.5" x 11" worksheet. I am having a difficult time resizing so that that all play nice on the same sheet. Is there an easy way to size multiple charts so they fit nicely on one page ? I have been dragging corners for hours but can't seem to get it right. Thanks, Orlando 
|
|
#2
August 31st, 2009, 07:24 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
4 graphs / one sheet / cramming for space
In general, pie charts are not a good choice for data displays. Human
perception is not so precise when judging angles or areas as lengths and distances, and pie charts use a lot of area to show a small amount of data. In most cases, data from multiple pie charts can be shown more effectively in a single bar or column chart. For example, see Column Chart to Replace Multiple Pie Charts http://peltiertech.com/WordPress/col...le-pie-charts/ Simple Bar Chart Beats Complex Multiple Sized Pies http://peltiertech.com/WordPress/sim...le-sized-pies/ - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ ORLANDO VAZQUEZ wrote: Hi, I have four pie charts that are displayed on one 8.5" x 11" worksheet. I am having a difficult time resizing so that that all play nice on the same sheet. Is there an easy way to size multiple charts so they fit nicely on one page ? I have been dragging corners for hours but can't seem to get it right. Thanks, Orlando
|
|
#3
August 31st, 2009, 07:34 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
4 graphs / one sheet / cramming for space
I totally agree with you, however, this won't change. Any other suggestions ?
"Jon Peltier" wrote: In general, pie charts are not a good choice for data displays. Human perception is not so precise when judging angles or areas as lengths and distances, and pie charts use a lot of area to show a small amount of data. In most cases, data from multiple pie charts can be shown more effectively in a single bar or column chart. For example, see Column Chart to Replace Multiple Pie Charts http://peltiertech.com/WordPress/col...le-pie-charts/ Simple Bar Chart Beats Complex Multiple Sized Pies http://peltiertech.com/WordPress/sim...le-sized-pies/ - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ ORLANDO VAZQUEZ wrote: Hi, I have four pie charts that are displayed on one 8.5" x 11" worksheet. I am having a difficult time resizing so that that all play nice on the same sheet. Is there an easy way to size multiple charts so they fit nicely on one page ? I have been dragging corners for hours but can't seem to get it right. Thanks, Orlando
|
|
#4
September 4th, 2009, 02:30 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
4 graphs / one sheet / cramming for space
I'm reluctant to offer advice on how to make a better pie chart, because
I have a reputation to uphold. However, I know what it's like being in an inflexible position. Make one pie chart, do all the formatting you need. Make three copies of this chart, and change the source data so that all four data ranges are represented. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ ORLANDO VAZQUEZ wrote: I totally agree with you, however, this won't change. Any other suggestions ? "Jon Peltier" wrote: In general, pie charts are not a good choice for data displays. Human perception is not so precise when judging angles or areas as lengths and distances, and pie charts use a lot of area to show a small amount of data. In most cases, data from multiple pie charts can be shown more effectively in a single bar or column chart. For example, see Column Chart to Replace Multiple Pie Charts http://peltiertech.com/WordPress/col...le-pie-charts/ Simple Bar Chart Beats Complex Multiple Sized Pies http://peltiertech.com/WordPress/sim...le-sized-pies/ - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ ORLANDO VAZQUEZ wrote: Hi, I have four pie charts that are displayed on one 8.5" x 11" worksheet. I am having a difficult time resizing so that that all play nice on the same sheet. Is there an easy way to size multiple charts so they fit nicely on one page ? I have been dragging corners for hours but can't seem to get it right. Thanks, Orlando
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
