Spreadsheet_Charts

=Spreadsheets - Survey Exercise= include component="page" page="menu-Applications" editable="1" include component="page" page="menu-spreadsheets" editable="1"
 * [[image:Spreadsheets_ChartSurvey01.png]] || Data must be arrange in labeled, consecutive cells.

In this example - The cell range from D32..G34 contains all the data necessary to create the chart below. || The options you set really depend on whether you've arranged your data into ROWS or COLUMNS (for the above, it's rows)
 * [[image:Spreadsheets_ChartSurvey02.png]] || SELECT the range that includes both labels and data (ie D32..H34).


 * Use INSERT CHART
 * Choose a BAR chart
 * Choose to STACK it
 * Add titles, legends and axis labels ||

Once you've completed your chart, you can
 * Converting a chart to a web-friendly jpg, gif or png**
 * 1) COPY the chart in Calc
 * 2) Open an NEW - OPEN OFFICE DRAWING
 * 3) PASTE the chart into the drawing file
 * 4) RESIZE and SELECT just that chart in the drawing
 * 5) Use FILE - EXPORT and choose an appropriate format

You can now use that graphic in a webpage!