Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating accessible color-independent charts in Excel 2007
I can't seem to figure out (it was easy in earlier versions!) how to
take pie charts (or other types of charts) and make them independent of color. I don't mind if the chart uses color, but I don't want to rely on color to make sure that people of varying sensitivities to color or a black and white photocopy doesn't put the user of the chart at a disadvantage. How can I have my different pie slices not just a different color, but in a different cross-hatch or other fill? Thanks, and sorry if this is obvious! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating accessible color-independent charts in Excel 2007
Hi,
They removed the UI for pattern fills in 2007. Fortunately the functionality is still available via code. I have an add-in that allows you to use pattern fills. http://www.andypope.info/charts/patternfills.htm There is a blog post by Eric Patterson, a program manager on the Excel team, on the subject. http://blogs.msdn.com/excel/archive/...ern-fills.aspx Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info wrote in message ... I can't seem to figure out (it was easy in earlier versions!) how to take pie charts (or other types of charts) and make them independent of color. I don't mind if the chart uses color, but I don't want to rely on color to make sure that people of varying sensitivities to color or a black and white photocopy doesn't put the user of the chart at a disadvantage. How can I have my different pie slices not just a different color, but in a different cross-hatch or other fill? Thanks, and sorry if this is obvious! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating accessible color-independent charts in Excel 2007
If you use a bar or column chart, you won't need different colors, because
each point will have its label along the category axis. You will make it easier to compare each point's value (pies are poor for this). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... I can't seem to figure out (it was easy in earlier versions!) how to take pie charts (or other types of charts) and make them independent of color. I don't mind if the chart uses color, but I don't want to rely on color to make sure that people of varying sensitivities to color or a black and white photocopy doesn't put the user of the chart at a disadvantage. How can I have my different pie slices not just a different color, but in a different cross-hatch or other fill? Thanks, and sorry if this is obvious! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating accessible color-independent charts in Excel 2007
Thanks, Andy! I really like your site and just played your sudoko
game. I am sorry that they removed this functionality, and am glad that I now have your addin. It works well, but is there a mode where it can automatically generate each chart element in different fill patterns rather than having to go in and have each element filled explicitly? Thanks for sharing your wisdom and Excel resources! Dilip On Feb 27, 3:42*am, "Andy Pope" wrote: Hi, They removed the UI for pattern fills in 2007. Fortunately the functionality is still available via code. I have an add-in that allows you to use pattern fills.http://www.andypope.info/charts/patternfills.htm There is a blog post by Eric Patterson, a program manager on the Excel team, on the subject.http://blogs.msdn.com/excel/archive/...ern-fills.aspx Cheers Andy -- Andy Pope, Microsoft MVP - wrote in message ... I can't seem to figure out (it was easy in earlier versions!) how to take pie charts (or other types of charts) and make them independent of color. I don't mind if the chart uses color, but I don't want to rely on color to make sure that people of varying sensitivities to color or a black and white photocopy doesn't put the user of the chart at a disadvantage. How can I have my different pie slices not just a different color, but in a different cross-hatch or other fill? Thanks, and sorry if this is obvious!- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating accessible color-independent charts in Excel 2007
Thanks, Jon. I like using pie charts when looking at fractionating a
whole. Plus I teach and want to make sure that my students can create charts of different types and not rely on color. Thanks! Dilip On Feb 27, 2:12*pm, "Jon Peltier" wrote: If you use a bar or column chart, you won't need different colors, because each point will have its label along the category axis. You will make it easier to compare each point's value (pies are poor for this). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... I can't seem to figure out (it was easy in earlier versions!) how to take pie charts (or other types of charts) and make them independent of color. I don't mind if the chart uses color, but I don't want to rely on color to make sure that people of varying sensitivities to color or a black and white photocopy doesn't put the user of the chart at a disadvantage. How can I have my different pie slices not just a different color, but in a different cross-hatch or other fill? Thanks, and sorry if this is obvious!- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating accessible color-independent charts in Excel 2007
Hi,
Thanks for the feedback. You could create a routine that formats all the slices of a selected chart with a set of patterns. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info wrote in message ... Thanks, Andy! I really like your site and just played your sudoko game. I am sorry that they removed this functionality, and am glad that I now have your addin. It works well, but is there a mode where it can automatically generate each chart element in different fill patterns rather than having to go in and have each element filled explicitly? Thanks for sharing your wisdom and Excel resources! Dilip On Feb 27, 3:42 am, "Andy Pope" wrote: Hi, They removed the UI for pattern fills in 2007. Fortunately the functionality is still available via code. I have an add-in that allows you to use pattern fills.http://www.andypope.info/charts/patternfills.htm There is a blog post by Eric Patterson, a program manager on the Excel team, on the subject.http://blogs.msdn.com/excel/archive/...ern-fills.aspx Cheers Andy -- Andy Pope, Microsoft MVP - wrote in message ... I can't seem to figure out (it was easy in earlier versions!) how to take pie charts (or other types of charts) and make them independent of color. I don't mind if the chart uses color, but I don't want to rely on color to make sure that people of varying sensitivities to color or a black and white photocopy doesn't put the user of the chart at a disadvantage. How can I have my different pie slices not just a different color, but in a different cross-hatch or other fill? Thanks, and sorry if this is obvious!- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating accessible color-independent charts in Excel 2007
A priori it would seem that pie charts would be good for looking at parts of
the whole, but they're not all that effective at it. May I direct you to this article by Stephen Few: Save the Pies for Dessert http://www.perceptualedge.com/articles/08-21-07.pdf As an educator, you should be concerned that your students learn not only how to make certain chart types, but also how to make effective chart types. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... Thanks, Jon. I like using pie charts when looking at fractionating a whole. Plus I teach and want to make sure that my students can create charts of different types and not rely on color. Thanks! Dilip On Feb 27, 2:12 pm, "Jon Peltier" wrote: If you use a bar or column chart, you won't need different colors, because each point will have its label along the category axis. You will make it easier to compare each point's value (pies are poor for this). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... I can't seem to figure out (it was easy in earlier versions!) how to take pie charts (or other types of charts) and make them independent of color. I don't mind if the chart uses color, but I don't want to rely on color to make sure that people of varying sensitivities to color or a black and white photocopy doesn't put the user of the chart at a disadvantage. How can I have my different pie slices not just a different color, but in a different cross-hatch or other fill? Thanks, and sorry if this is obvious!- Hide quoted text - - Show quoted text - |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating accessible color-independent charts in Excel 2007
Thanks, Jon, for the pointer to your detailed article! I also have a
background in ease of use, so appreciate the perspective. I am going to add a pointer to your article to my class notes to share with future students. In class, I do warn students to use charts effectively and point out that one can mislead especially with 3D charts. Thanks! Dilip On Feb 28, 8:23*am, "Jon Peltier" wrote: A priori it would seem that pie charts would be good for looking at parts of the whole, but they're not all that effective at it. May I direct you to this article by Stephen Few: Save the Pies for Desserthttp://www.perceptualedge.com/articles/08-21-07.pdf As an educator, you should be concerned that your students learn not only how to make certain chart types, but also how to make effective chart types. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Thanks, Jon. I like using pie charts when looking at fractionating a whole. Plus I teach and want to make sure that my students can create charts of different types and not rely on color. Thanks! * * * * *Dilip On Feb 27, 2:12 pm, "Jon Peltier" wrote: If you use a bar or column chart, you won't need different colors, because each point will have its label along the category axis. You will make it easier to compare each point's value (pies are poor for this). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... I can't seem to figure out (it was easy in earlier versions!) how to take pie charts (or other types of charts) and make them independent of color. I don't mind if the chart uses color, but I don't want to rely on color to make sure that people of varying sensitivities to color or a black and white photocopy doesn't put the user of the chart at a disadvantage. How can I have my different pie slices not just a different color, but in a different cross-hatch or other fill? Thanks, and sorry if this is obvious!- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating accessible color-independent charts in Excel 2007
That's not my article, it's Stephen Few's. I'm slowly developing similar and
complementary content for my blog. So many people write about effective charting practices, but not many direct their attentions at Excel charting. Charley Kyd (http://exceluser.com) is one of a handful, and I'm trying to help fill in gaps. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... Thanks, Jon, for the pointer to your detailed article! I also have a background in ease of use, so appreciate the perspective. I am going to add a pointer to your article to my class notes to share with future students. In class, I do warn students to use charts effectively and point out that one can mislead especially with 3D charts. Thanks! Dilip On Feb 28, 8:23 am, "Jon Peltier" wrote: A priori it would seem that pie charts would be good for looking at parts of the whole, but they're not all that effective at it. May I direct you to this article by Stephen Few: Save the Pies for Desserthttp://www.perceptualedge.com/articles/08-21-07.pdf As an educator, you should be concerned that your students learn not only how to make certain chart types, but also how to make effective chart types. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Thanks, Jon. I like using pie charts when looking at fractionating a whole. Plus I teach and want to make sure that my students can create charts of different types and not rely on color. Thanks! Dilip On Feb 27, 2:12 pm, "Jon Peltier" wrote: If you use a bar or column chart, you won't need different colors, because each point will have its label along the category axis. You will make it easier to compare each point's value (pies are poor for this). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... I can't seem to figure out (it was easy in earlier versions!) how to take pie charts (or other types of charts) and make them independent of color. I don't mind if the chart uses color, but I don't want to rely on color to make sure that people of varying sensitivities to color or a black and white photocopy doesn't put the user of the chart at a disadvantage. How can I have my different pie slices not just a different color, but in a different cross-hatch or other fill? Thanks, and sorry if this is obvious!- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating accessible color-independent charts in Excel 2007
Thanks. I meant to say the article that you referred to. I've already
created a link to it for my students with Stephen Few's name mentioned as the author. --Dilip On Mar 7, 12:11*am, "Jon Peltier" wrote: That's not my article, it's Stephen Few's. I'm slowly developing similar and complementary content for my blog. So many people write about effective charting practices, but not many direct their attentions at Excel charting.. Charley Kyd (http://exceluser.com) is one of a handful, and I'm trying to help fill in gaps. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Thanks, Jon, for the pointer to your detailed article! I also have a background in ease of use, so appreciate the perspective. I am going to add a pointer to your article to my class notes to share with future students. In class, I do warn students to use charts effectively and point out that one can mislead especially with 3D charts. Thanks! * * * *Dilip On Feb 28, 8:23 am, "Jon Peltier" wrote: A priori it would seem that pie charts would be good for looking at parts of the whole, but they're not all that effective at it. May I direct you to this article by Stephen Few: Save the Pies for Desserthttp://www.perceptualedge.com/articles/08-21-07.pdf As an educator, you should be concerned that your students learn not only how to make certain chart types, but also how to make effective chart types. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Thanks, Jon. I like using pie charts when looking at fractionating a whole. Plus I teach and want to make sure that my students can create charts of different types and not rely on color. Thanks! Dilip On Feb 27, 2:12 pm, "Jon Peltier" wrote: If you use a bar or column chart, you won't need different colors, because each point will have its label along the category axis. You will make it easier to compare each point's value (pies are poor for this). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message .... I can't seem to figure out (it was easy in earlier versions!) how to take pie charts (or other types of charts) and make them independent of color. I don't mind if the chart uses color, but I don't want to rely on color to make sure that people of varying sensitivities to color or a black and white photocopy doesn't put the user of the chart at a disadvantage. How can I have my different pie slices not just a different color, but in a different cross-hatch or other fill? Thanks, and sorry if this is obvious!- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#11
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating accessible color-independent charts in Excel 2007
I forgot to mention that you ought to browse through all of the articles on
Stephen's site, because there are lots of good ones. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... Thanks. I meant to say the article that you referred to. I've already created a link to it for my students with Stephen Few's name mentioned as the author. --Dilip On Mar 7, 12:11 am, "Jon Peltier" wrote: That's not my article, it's Stephen Few's. I'm slowly developing similar and complementary content for my blog. So many people write about effective charting practices, but not many direct their attentions at Excel charting. Charley Kyd (http://exceluser.com) is one of a handful, and I'm trying to help fill in gaps. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Thanks, Jon, for the pointer to your detailed article! I also have a background in ease of use, so appreciate the perspective. I am going to add a pointer to your article to my class notes to share with future students. In class, I do warn students to use charts effectively and point out that one can mislead especially with 3D charts. Thanks! Dilip On Feb 28, 8:23 am, "Jon Peltier" wrote: A priori it would seem that pie charts would be good for looking at parts of the whole, but they're not all that effective at it. May I direct you to this article by Stephen Few: Save the Pies for Desserthttp://www.perceptualedge.com/articles/08-21-07.pdf As an educator, you should be concerned that your students learn not only how to make certain chart types, but also how to make effective chart types. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... Thanks, Jon. I like using pie charts when looking at fractionating a whole. Plus I teach and want to make sure that my students can create charts of different types and not rely on color. Thanks! Dilip On Feb 27, 2:12 pm, "Jon Peltier" wrote: If you use a bar or column chart, you won't need different colors, because each point will have its label along the category axis. You will make it easier to compare each point's value (pies are poor for this). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... I can't seem to figure out (it was easy in earlier versions!) how to take pie charts (or other types of charts) and make them independent of color. I don't mind if the chart uses color, but I don't want to rely on color to make sure that people of varying sensitivities to color or a black and white photocopy doesn't put the user of the chart at a disadvantage. How can I have my different pie slices not just a different color, but in a different cross-hatch or other fill? Thanks, and sorry if this is obvious!- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 - change fill color from one color to another | Excel Discussion (Misc queries) | |||
Creating custom charts in Excel 2007 | Charts and Charting in Excel | |||
Radar charts with independent axes | Charts and Charting in Excel | |||
Creating charts in Excel... | Excel Discussion (Misc queries) | |||
Excel: creating a group of independent option buttons | Excel Discussion (Misc queries) |