Click here to see the SAS code.
Click here to see the example.

For comparison, see diesel sales, plotted to same time scale
(only a few years of data available though...)
Diesel Vehicle sales graphs

---------------------------------------------------------------

Data copy-n-pasted from the "dashboards" on this site:
http://www.hybridcars.com/hybrid-clean-diesel-sales-dashboard/may-2010.html
http://www.hybridcars.com/market-dashboard/august-2008-dashboard-undersupply-and-discouraged-buyers-24953.html
and so on...

Imported the spreadsheet into a SAS data set using:

PROC IMPORT OUT=hybrids DATAFILE="hybrids.xls" DBMS=EXCEL REPLACE;
     RANGE="Sheet1$";
     GETNAMES=YES;
     MIXED=NO;
     SCANTEXT=YES;
     USEDATE=YES;
     SCANTIME=YES;
RUN;

---

Plotted the data using "proc gchart" grouped bar chart, etc.

The main "neat" thing here is the drilldowns...
From the main chart, you can click on the bar segments (manufacturers) 
to drilldown to a chart for just that manufacturer.  Similarly, you
can click on the manufacturers' color chicklets in the legend to
drilldown to the manufacturer chart.

From the manufacturer charts, you can click on the bar segments (model)
to drilldown and see pictures of that year/manuf/model car (via google).
Similarly, you can click on the models' color chicklets in the legend
to drilldown to the google pictures.

In all charts, you can click on the month (below the bar) to drilldown
to the hybridcars.com report for that month (ie, the original source
of the data I used).  I did this special drilldown using 'invisible'
(same color as background) annotated text with 'html=' drilldown.

Back to Samples Index