Here is my scenario: I have a spreadsheet of data for my vehicle's service and gas records. Here is a snippet from the CSV:
"Type","MPG","Date","Time","Vehicle","Odometer","Filled Up","Cost/ Gallon","Gallons","Total Cost","Octane","Gas Brand","Location","Tags","Payment Type","Tire Pressure","Notes","Total Cost","Services" "Gas","0.0","2012-04-23","4:52 PM","Mazdaspeed 3","98,891","Full","$3.709","12.106","$44.90","93","BP","25th street, canton, oh","","BP Visa","32.0","","$44.90","" "Gas","26.4","2012-04-18","5:15 PM","Mazdaspeed 3","98,572","Full","$2.759","12.113","$33.42","93","BP","Rocky River BP","","BP Visa","32.0","","$33.42","" "Gas","0.0","2012-04-15","4:33 PM","Mazda CX-7","67,326","Reset","$4.079","14.484","$59.08","93","BP","1120 N Tuscarawas Ave, Dover, OH, 44622","","BP Visa","34.0","","$59.08","" "Gas","26.7","2012-04-14","3:20 PM","Mazdaspeed 3","98,249","Full","$4.079","12.150","$49.56","93","BP","1120 N Tuscarawas Ave, Dover, OH, 44622","","BP Visa","32.0","","$49.56","" "Service","0.0","2012-04-11","8:09 PM","Mazdaspeed 3","98,123","","$0.000","0.000","$388.75","","","3171 S Arlington St, Akron, OH, 44312","","BP Visa","32.0","Changed spark plugs with stock replacements, fixed CEL with purge valve replacement","$388.75","Spark Plugs, Purge Valve Replacement" "Service","0.0","2012-04-04","6:05 PM","Mazda CX-7","66,528","","$0.000","0.000","$932.81","","","3171 S Arlington St, Akron, OH, 44312","","BP Visa","33.0","New tires, alignment, oil change, and inspection","$932.81","Air Filter, Antifreeze, Inspection, Oil Change, Rotate Tires, Tire A, Tire B, Tire C, Tire D, Wheel Alignment" I want to create a chart with: 1. X-Axis of Miles Per Gallon 2. Y-Axis of either Odometer or Date base (right now I am currently using Date) What I would like to do is have my Gas entries as the main data, and lay the service records over top at a certain Date or Odometer point (horizontal axis). I have it working with the annotation and annotationText, and I have: 1. Sorted my dataset by time 2. Grouped by the date (in the cases where there is both a gas entry and service entry) There are some cases where there is only a service entry, and therefore the main data on my line gets skewed because there is no MPG to report. I realize I could calculate the difference between the previous/next fillup - but I figured it would be easier if there was a way to just lay the annotations over top of the MPG data points (rather than injecting them in). Think like Google Analytics - where I can attach an annotation to a point in time, not to a specific data point on the chart. Has anyone done anything like this? I have read through the LineChart docs, as well as the Roles documentation to see how I can set annotations. Thanks, Nate -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
