| Author | |
|---|
Apedemak
Villager
| Joined: | Sunday October 17th, 2004 |
| Location: | |
| Posts: | 3135 |
| Photo: | [Download] |
| Status: |
Offline
|
| Mana: |   |
Click here for your Black Profile
Search for Black Sites
|
Posted: Thursday August 31st, 2006 18:16 |
|
Whats up...
Need some help making a line graph with excel. For some reason I can't get the (x) axis to show the right information. 
I'm making a line graph to show the volume of sales of individual product types from month to month so its supposed to be;
(y) axis = Volume in hundreds 100 - 200 - 300 - 1000 with detail on the lesser multitudes laddered for accurate reading. The true amounts should be readable when needed by clicking on the marker I'm sure.
(x) axis = Months Jan - Dec. Marked weekly.
Hoping to chart the total sales of said product for the month on another graph.
Problem is that I don't seem able to set the (x) axis and set the product types, the two clash when they shouldn't. I should be able to have them seperate.
(y) Axis = Volume
(x) Axis = Timespan
Legend = Product 01/Product 02...
Can anyone help me out here? 
Thanks
R.L
____________________
____________________
Click here for your Black Profile
|
cell
Villager
| Joined: | Friday February 4th, 2005 |
| Location: | |
| Posts: | 169 |
| Photo: | |
| Status: |
Offline
|
| Mana: |  |
Click here for your Black Profile
Search for Black Sites
|
Posted: Thursday August 31st, 2006 18:42 |
|
This tutorial might help you
http://www.ncsu.edu/labwrite/res/gt/gt-bar-home.html
____________________
www.blacksearch.co.uk - Helping to promote Black African and Caribbean Websites
|
MCP
Villager
| Joined: | Thursday October 21st, 2004 |
| Location: | London, United Kingdom |
| Posts: | 296 |
| Photo: | |
| Status: |
Offline
|
| Mana: | |
Click here for your Black Profile
Search for Black Sites
|
Posted: Friday September 1st, 2006 00:24 |
|
cell wrote: This tutorial might help you
http://www.ncsu.edu/labwrite/res/gt/gt-bar-home.html
I was about to state about using the chart wizard on excel. But Cell beat me to it.
Good info anyway.
____________________
Click here for your Black Profile
|
YankeeJamaRican
Villager
Click here for your Black Profile
Search for Black Sites
|
Posted: Friday September 1st, 2006 13:14 |
|
Thing is, he is doing a line graph, not a bar... although I find the bar graphs a bit easier to deal with visually.
The key to a good graph is the way you set up the underlying table, as well as how you set up your series when you create the graph... uses the series popup box to highlight the right areas of the table and it should show a preview of what your graph will look like.
PM me if you want specific help, but it doesn't sound tough to do if you tinker with the series and axes.
____________________
____________________
www.blacksearch.co.uk - Helping to promote Black African and Caribbean Websites
|
Apedemak
Villager
| Joined: | Sunday October 17th, 2004 |
| Location: | |
| Posts: | 3135 |
| Photo: | [Download] |
| Status: |
Offline
|
| Mana: | |
Click here for your Black Profile
Search for Black Sites
|
Posted: Friday September 1st, 2006 18:56 |
|
Yup.
Its about bar graphs still helpful... that lil clip thing dosen't do anything... man I wish I'd noticed this thread earlier... ummm... I've got it all on screen but now I can't get the diffrent products to change. Theres only one line and not the others in the key... this shouldn't be so hard to do. Can't seem to change any thing but the one product... 
____________________
____________________
Click here for your Black Profile
|
Apedemak
Villager
| Joined: | Sunday October 17th, 2004 |
| Location: | |
| Posts: | 3135 |
| Photo: | [Download] |
| Status: |
Offline
|
| Mana: | |
Click here for your Black Profile
Search for Black Sites
|
Posted: Saturday September 2nd, 2006 17:52 |
|
Clocked it.
Thanks! 
____________________
____________________
www.blacksearch.co.uk - Helping to promote Black African and Caribbean Websites
|
|
|
Current time is 22:54 | |
|
