bryanleister
YaBB Newbies
Offline
Posts: 3
Visualizing Data question
Jun 13th , 2008, 6:41pm
I have been working through the tutorials in Visualizing Data, and it's been a great resource. After completing each one I feel like an expert! But now, I'm trying to start branching out and doing my own code, it isn't quite as smooth... My question is very simple, but I can't seem to find any resources to answer and figure it out. I have imported a database and want a chart to be created very similar to the Milk-tea-coffee database. The difference is that I want to also separate by month, not just years in the display. My data is in the form: Year, Month, Milk 2003, 1, 35 Using the example from the book, the data is all stacked up as points within each year, one on top of another. I'd really like to figure out the logic and approach to solving this simple problem. How do I interpolate the 12 months of the year in between each year? Also, how do I prevent the Month column from being displayed as part of the chart? I know I could probably do some ugly hack, like changing the data to a running number for months and generate a decent looking chart, but I'd like to understand the "proper" way to approach a problem like this. It seems like something that divides or lists the points between 0 and 11 within each year would do it, but I just can't make the connection into how to go about setting up an array like that. I have searched through the forums quite a bit, but with the keywords "month" or "year" it's really hard to find relevant info, here or through the web in general. Thanks in advance for any guidance, and particularly for an explanation of the rationale behind the approach. Cheers, Bryan