|
Multiple Pie Charts
I have two years worth of data that I would like to put in separate pie
charts - side by side. Is there a way to do this with one chart that contains two pies or do they have to be two separate pies? I'm actually doing this in Word and I was concerned about getting everything to line up correctly. Thanks in advance for any help! |
Multiple Pie Charts
Hi Kathleen,
First thing - what version of Word are we talking about here? Unless you are working in 2007, it would be best to post this to Word if you are doing it in Word. -- Thanks, Shane Devenshire "Kathleen" wrote: I have two years worth of data that I would like to put in separate pie charts - side by side. Is there a way to do this with one chart that contains two pies or do they have to be two separate pies? I'm actually doing this in Word and I was concerned about getting everything to line up correctly. Thanks in advance for any help! |
Multiple Pie Charts
Tufte once said, The only thing worse than a pie chart is multiple pie
charts (or words to that effect). A pie chart by itself is a poor choice to show all but the most trivial sets of data. Despite people's over-familiarity with pie charts, they do not read these charts as accurately as they think they do. Putting two pies side by side forces the user to make comparisons between two sets of hard to comprehend data sets. In addition to the difficulty the user has with multiple pie charts, the creator has to use separate charts, and try to line them up and size them equally. Could you use a line chart with two sets of lines, or better, something like a Dot Plot? http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Kathleen" wrote in message ... I have two years worth of data that I would like to put in separate pie charts - side by side. Is there a way to do this with one chart that contains two pies or do they have to be two separate pies? I'm actually doing this in Word and I was concerned about getting everything to line up correctly. Thanks in advance for any help! |
Multiple Pie Charts
Hi Jon,
I have all but the very latest Tufte book, you must remember the Napoleon march into Russia chart, no? He was out here doing a full day class, but I didn't go because it was about $300. -- Cheers, Shane Devenshire "Jon Peltier" wrote: Tufte once said, The only thing worse than a pie chart is multiple pie charts (or words to that effect). A pie chart by itself is a poor choice to show all but the most trivial sets of data. Despite people's over-familiarity with pie charts, they do not read these charts as accurately as they think they do. Putting two pies side by side forces the user to make comparisons between two sets of hard to comprehend data sets. In addition to the difficulty the user has with multiple pie charts, the creator has to use separate charts, and try to line them up and size them equally. Could you use a line chart with two sets of lines, or better, something like a Dot Plot? http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Kathleen" wrote in message ... I have two years worth of data that I would like to put in separate pie charts - side by side. Is there a way to do this with one chart that contains two pies or do they have to be two separate pies? I'm actually doing this in Word and I was concerned about getting everything to line up correctly. Thanks in advance for any help! |
Multiple Pie Charts
I took his class a few years back, very worthwhile. The fee includes three
or four of his books, plus a large poster of the Napoleon's March chart. The fee was a business expense anyway. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Hi Jon, I have all but the very latest Tufte book, you must remember the Napoleon march into Russia chart, no? He was out here doing a full day class, but I didn't go because it was about $300. -- Cheers, Shane Devenshire "Jon Peltier" wrote: Tufte once said, The only thing worse than a pie chart is multiple pie charts (or words to that effect). A pie chart by itself is a poor choice to show all but the most trivial sets of data. Despite people's over-familiarity with pie charts, they do not read these charts as accurately as they think they do. Putting two pies side by side forces the user to make comparisons between two sets of hard to comprehend data sets. In addition to the difficulty the user has with multiple pie charts, the creator has to use separate charts, and try to line them up and size them equally. Could you use a line chart with two sets of lines, or better, something like a Dot Plot? http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Kathleen" wrote in message ... I have two years worth of data that I would like to put in separate pie charts - side by side. Is there a way to do this with one chart that contains two pies or do they have to be two separate pies? I'm actually doing this in Word and I was concerned about getting everything to line up correctly. Thanks in advance for any help! |
Multiple Pie Charts
|
Multiple Pie Charts
Hi Jon,
A business expense, now why didn't I think of that! I work for myself, but I could still write it off, thanks for a great idea! -- Thanks, Shane Devenshire "Jon Peltier" wrote: I took his class a few years back, very worthwhile. The fee includes three or four of his books, plus a large poster of the Napoleon's March chart. The fee was a business expense anyway. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Hi Jon, I have all but the very latest Tufte book, you must remember the Napoleon march into Russia chart, no? He was out here doing a full day class, but I didn't go because it was about $300. -- Cheers, Shane Devenshire "Jon Peltier" wrote: Tufte once said, The only thing worse than a pie chart is multiple pie charts (or words to that effect). A pie chart by itself is a poor choice to show all but the most trivial sets of data. Despite people's over-familiarity with pie charts, they do not read these charts as accurately as they think they do. Putting two pies side by side forces the user to make comparisons between two sets of hard to comprehend data sets. In addition to the difficulty the user has with multiple pie charts, the creator has to use separate charts, and try to line them up and size them equally. Could you use a line chart with two sets of lines, or better, something like a Dot Plot? http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Kathleen" wrote in message ... I have two years worth of data that I would like to put in separate pie charts - side by side. Is there a way to do this with one chart that contains two pies or do they have to be two separate pies? I'm actually doing this in Word and I was concerned about getting everything to line up correctly. Thanks in advance for any help! |
Multiple Pie Charts
Plus the mileage there and back, and half of lunch.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Hi Jon, A business expense, now why didn't I think of that! I work for myself, but I could still write it off, thanks for a great idea! -- Thanks, Shane Devenshire "Jon Peltier" wrote: I took his class a few years back, very worthwhile. The fee includes three or four of his books, plus a large poster of the Napoleon's March chart. The fee was a business expense anyway. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Hi Jon, I have all but the very latest Tufte book, you must remember the Napoleon march into Russia chart, no? He was out here doing a full day class, but I didn't go because it was about $300. -- Cheers, Shane Devenshire "Jon Peltier" wrote: Tufte once said, The only thing worse than a pie chart is multiple pie charts (or words to that effect). A pie chart by itself is a poor choice to show all but the most trivial sets of data. Despite people's over-familiarity with pie charts, they do not read these charts as accurately as they think they do. Putting two pies side by side forces the user to make comparisons between two sets of hard to comprehend data sets. In addition to the difficulty the user has with multiple pie charts, the creator has to use separate charts, and try to line them up and size them equally. Could you use a line chart with two sets of lines, or better, something like a Dot Plot? http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Kathleen" wrote in message ... I have two years worth of data that I would like to put in separate pie charts - side by side. Is there a way to do this with one chart that contains two pies or do they have to be two separate pies? I'm actually doing this in Word and I was concerned about getting everything to line up correctly. Thanks in advance for any help! |
| All times are GMT +1. The time now is 07:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com