Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Which chart type to use
This should be pretty simple, I need to compare the body weight and brain
weights of 3 different animals. THere is a signifigant difference between the brain and body weight of each, for instance, Humans are avg 160 lbs and brain is 3.5 lbs. I tried a column chart but you dont see the brain data, it is too small compared to the body weight. What type of chart would best display this data? Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Which chart type to use
XY chart, body weight along X, brain weight along Y, data labels to identify
the species. Use one of these utilities to provide the custom data labels: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vicky" wrote in message ... This should be pretty simple, I need to compare the body weight and brain weights of 3 different animals. THere is a signifigant difference between the brain and body weight of each, for instance, Humans are avg 160 lbs and brain is 3.5 lbs. I tried a column chart but you dont see the brain data, it is too small compared to the body weight. What type of chart would best display this data? Thanks. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Which chart type to use
I used the XY chart, but I am not seeing how this is helpful. The X and Ys
do not seem to be aligned with eachother. Is this what the utility does? Tried downloading the first, but it ddnt work. COuldnt find the second. Any other thoughts? "Jon Peltier" wrote: XY chart, body weight along X, brain weight along Y, data labels to identify the species. Use one of these utilities to provide the custom data labels: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vicky" wrote in message ... This should be pretty simple, I need to compare the body weight and brain weights of 3 different animals. THere is a signifigant difference between the brain and body weight of each, for instance, Humans are avg 160 lbs and brain is 3.5 lbs. I tried a column chart but you dont see the brain data, it is too small compared to the body weight. What type of chart would best display this data? Thanks. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Which chart type to use
I don't know what you mean, that the X and Y are not aligned with each
other. I looked up some data from the web and made two charts, one a regular XY chart, and one with logarithmic scales for X and Y. Check it out: http://peltiertech.com/Excel/Zips/BrainBodySize.zip - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ I looked up data "Vicky" wrote in message ... I used the XY chart, but I am not seeing how this is helpful. The X and Ys do not seem to be aligned with eachother. Is this what the utility does? Tried downloading the first, but it ddnt work. COuldnt find the second. Any other thoughts? "Jon Peltier" wrote: XY chart, body weight along X, brain weight along Y, data labels to identify the species. Use one of these utilities to provide the custom data labels: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vicky" wrote in message ... This should be pretty simple, I need to compare the body weight and brain weights of 3 different animals. THere is a signifigant difference between the brain and body weight of each, for instance, Humans are avg 160 lbs and brain is 3.5 lbs. I tried a column chart but you dont see the brain data, it is too small compared to the body weight. What type of chart would best display this data? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine a Bubble chart with other chart type | Charts and Charting in Excel | |||
Pivot Chart - default chart type | Excel Discussion (Misc queries) | |||
Chart Type toolbutton instead of Chart Wizard | Charts and Charting in Excel | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel |