Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bevaior Chart Graph
I need urgent help for creating a graph for my research, I have been
collecting information on river otter's activities in a set amount of time, and have a visually appealing spreedsheet. Ex: (Timings) 1 2 3 4 5 Aggression B BC C B 2 Play C B C Where the letters each individual otter and the 2 represents both cooperating in the activity. I need to create a graph, any will do at this point, with this information. I have tried several methods, & have problems using text variables as well as keeping blank cells from attributing data. If Excel isn't up to the task, I have access to any office program as well as in depth knowledge of Excel, so don't hesitate with any suggestions. Thank you. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bevaior Chart Graph
The chart should display
(Timings) 1 2 3 4 5 Aggression B BC C B 2 Play C B C |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bevaior Chart Graph
Charts cannot plot text values as anything other than zero.
What you need to do is decide how this should look visually. Then decide on a chart type in Excel which would provide that visual appearance. Come up with a numerical equivalence to the letters in the table. Decide how to deal with multiple individuals in the same cell of the data (seems to me you should have one row/column per individual, or come up with another way to depict cooperative behavior). Then try making your chart, and if it still causes problems, post back here, explain what you've tried, how you want it to look, and how it looks instead. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Kitsune" wrote in message ... I need urgent help for creating a graph for my research, I have been collecting information on river otter's activities in a set amount of time, and have a visually appealing spreedsheet. Ex: (Timings) 1 2 3 4 5 Aggression B BC C B 2 Play C B C Where the letters each individual otter and the 2 represents both cooperating in the activity. I need to create a graph, any will do at this point, with this information. I have tried several methods, & have problems using text variables as well as keeping blank cells from attributing data. If Excel isn't up to the task, I have access to any office program as well as in depth knowledge of Excel, so don't hesitate with any suggestions. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Specifying chart graph | Charts and Charting in Excel | |||
Need help with chart graph not on chart wizard | Charts and Charting in Excel | |||
Conditional Chart/Graph? | Excel Discussion (Misc queries) | |||
Chart / Graph | Excel Discussion (Misc queries) | |||
Chart/Graph Help | Charts and Charting in Excel |