 |
welcome, guest |
| Help Forum | ||||
 |
| |||
 Malkin   Manager  |
I have a large volume of data in Excel. (Somewhere in the order of 30,000 rows of it.) I'm trying to make a line graph, and have succeeded thus far - but there's a slight hitch. For about the first third of my data set, nothing happens. This is what I predicted, but I'd like to exclude those '0' points from my data set, have the chart begin at the 00:36:00 mark (or so).  My hope is that by excluding the first third of the chart, it will make the rest of the data easier to interpret. Because I'm working with such a large data set, is there any easy way to do this? My TCR Norns |
|||
 Caves Dweller Rascii Administrator |
Can you just delete all rows containing 0 from the dataset? - Rascii |
|||
Malkin Manager |
So far, I've tried to use a "sheet setting" to remove 0 from the dataset. This does not automatically alter my chart to start where the non-zero data starts. My TCR Norns |
|||
 Peppery One Papriko |
I think you can right-click somewhere on the X-axis or it's labels and then have the option to change the axis' settings. There it should be possible to change the start and end points, spacing and other stuff. Lets play plants! Photosynthesis... Photosynthesis... Photosynthesis... |
|||
 Senior Wrangler Nutter |
If you right-click on your chart, you should have a menu option to select data. At that point, a window opens up where you can select a range of your data to use - so you should be able to just input the range of non-zero data, assuming it's consecutive. (On the assumption that Excel for Mac works like Excel for Windows, that is!) |
|||
| downloads cobs adoptions creaturelink metarooms breeds gallery art wallpaper screenshots graphics promos sprites |
dev hack shack script reservations dev resources active projects dev forum community links advice chat polls resources |
creatchi forum bookmarks general news help development strangeo survivor |
mycaves log in register lost pw |
2 online Papriko Shooshadragon13 |
| creatures caves is your #1 resource for the creatures artificial life game series: creatures, creatures 2, creatures 3, docking station, and the upcoming creatures family. contact help privacy policy terms & conditions rules donate wiki |
||||