You might want to try Domain Axis annotations. Set up your 'annotation'
and 'annotationText' columns after the domain column and setting the
annotation.<columnId>.style option to 'line':
annotation: {'*column_id*': {style: 'line'}}
On Wednesday, April 25, 2012 2:27:39 PM UTC-4, Nate Klaiber wrote:
>
> 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 view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/1NzNV6bwUx8J.
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.
