| View previous topic :: View next topic |
| Author |
Message |
rene
Power User
Joined: 20 Jun 2003
Posts: 88
|
 Posted: Wed Sep 29, 2004 1:56 am Post subject: how to edit the legend of a pie chart? |
 |
|
I have a spreadsheet from which I have created a pie chart using data from row 100. The titles for each column are located on row 1.
When I choose the data range in the pie chart auto format option, the data is displayed in the pie chart but I cannot find a way to edit the legend (which automatically shows column A, column B, etc. instead of my titles from column in row 1).
Can someone suggest how I can edit the legend to select my (title) cells on row 1?
Thanks in advance. |
|
| Back to top |
|
 |
maxqnz
Super User
Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa
|
| Posted: Wed Sep 29, 2004 2:51 am Post subject: |
|
|
Would you mind having a look at this page, and talk me through how it differs from your results?
_________________
Noho ora mai, ka kite ano.
What Is A Pieriansipist?
OOo 2.4/XP Pro SP2 / OOo 2.3.0.1/OpenSuse 10.3 |
|
| Back to top |
|
|
rene
Power User
Joined: 20 Jun 2003
Posts: 88
|
| Posted: Wed Sep 29, 2004 2:13 pm Post subject: pie chart legend edit |
|
|
Thanks for your internet web link, I noticed in one of the diagrams of the data source, there is a punctuation mark (semi-colon?) between the cells references for the titles and the cells containing data.
I shall try this observation to see if it works... |
|
| Back to top |
|
|
maxqnz
Super User
Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa
|
| Posted: Wed Sep 29, 2004 3:32 pm Post subject: |
|
|
If that doesn't help, let us know. 
_________________
Noho ora mai, ka kite ano.
What Is A Pieriansipist?
OOo 2.4/XP Pro SP2 / OOo 2.3.0.1/OpenSuse 10.3 |
|
| Back to top |
|
|
|
