[users] Multiple series of data in a chart

2006-07-06 Thread Craig Stevens
Hi ALL, Quick question, looked in documentation but didn't find, does calc charts support multiple data series, I have figure for the first 6 months of the year and the average, I can plot all in the one graph as regular bars but I want to plot the average as a line across the monthly figures.

Re: [users] Multiple series of data in a chart

2006-07-06 Thread Peter Kupfer
Craig -- You can't have a line graph and a bar graph on the same plot. However, you can create an average line on the bar graph using the statistics abilities of Calc. I typed up some instructions here: http://openoffice.peschtra.com/tips/ooott_calc_bar_graph_average.shtml HTH, Peter Craig

RE: [users] Multiple series of data in a chart

2006-07-06 Thread Craig Stevens
Thankyou very much, very clear and concise, and its worked like a charm. Thanks Peter -Original Message- From: Peter Kupfer [mailto:[EMAIL PROTECTED] Sent: Friday, 7 July 2006 3:28 PM To: users@openoffice.org Subject: Re: [users] Multiple series of data in a chart Craig -- You can't