Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() And visual information such as colour, shape is much easier to understand when looking at a graph. Color maybe, shape not so much. I would think a colored label would be as effective as a colored marker, as long as the label were kept to a character or two in length. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "itkovian" wrote in message ups.com... On Sep 18, 7:53 pm, Del Cotter wrote: On Tue, 18 Sep 2007, in microsoft.public.excel.charting, itkovian said: I have a set of data I wish to graph in a scatterplot. Each data point has two identification codes, coming from two separate groups, e.g., L = {a,b,c,d,e} and C = {1,2,3,4}. So you might have points I wish to use both colour and shape to identify the data points, e.g. all a's should be yellow, all b's red, etc. and all 1's should be a triangle, all 2's a square etc. It seems to me that you are coding the codes. Why would you create a code 1, 2, 3, etc., and then represent them by triangle, square, etc.? Because in reality the labels als much longer :-) And visual information such as colour, shape is much easier to understand when looking at a graph. We're trained to do it, letter codes are much more difficult. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
shape color | Excel Discussion (Misc queries) | |||
How do I color only half of shape? | Excel Worksheet Functions | |||
Change the shape of points to crosses in a chart | Charts and Charting in Excel | |||
Excel should allow auto shape boxes to be fixed to points on the g | Excel Discussion (Misc queries) | |||
How to change shape of points in chart? | Charts and Charting in Excel |