lismurn wrote > > With regard to Jays solution, I need all the data on page 1 as I have > two different charts, the pie chart requires all data whereas the bar > chart only requires the data which I want to use. One of my problems > is that if I disregard the date rows from Dec 2008 to Dec 2009 I also > lose the column headings. >
You just need to edit the Data Ranges in your charts. Replace with this for your first chart $'Dec 2011'.$A$18:$B$41;$'Dec 2011'.$B$3:$B$4;$'Dec 2011'.$H$3:$H$4;$'Dec 2011'.$H$18:$H$41 The problem is that you need to redefine the Range for Name in the Data Series tab. -- View this message in context: http://nabble.documentfoundation.org/Re-Changing-data-on-a-chart-tp3572779p3577223.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
