At 14:53 31/07/2015 +0000, Burak Omer Saracoglu wrote:
I draw a chart by Calc. Then I copy it and paste is. Years on x axis
automatically are changed. I copy it and paste to and image
software, years also are changed. Every attempt is same. Always
years are changed.
Computers are nothing if not consistent!
Does anyone know why? How can I fix or solve this problem?
I'm guessing here, but ...
Are your years genuine date values in the original data in the
spreadsheet? If so, remember that what you see in the cells is
controlled by the cell formatting as well as the actual values. When
you create a chart from these values, Calc inherits this formatting
by default into the chart labels. This inheritance is dynamic, so
that subsequent changes to the data cell formatting are carried
through to the chart. When you paste the chart into another product,
the connection with that formatting is apparently broken and the
labels relax into some default formatting. If this is your problem,
there appear to be two simple ways to solve it.
1. (Not recommended)
Enter your year values as text instead of genuine dates. Format the
cells as Text before entering the values. The values will be
incorporated into the chart as plain text and there should be no
change when you copy and paste the chart elsewhere.
2. (Recommended)
Format the year values explicitly in the chart instead of allowing
the formatting to be inherited from the data values.
o Keep your data as genuine dates. Don't worry too much about what
date format they have.
o Create the chart.
o Double-click the chart - so you see the grey border.
o Double-click the x-axis to bring up the x-Axis dialogue.
o Select the Numbers tab.
o Remove the tick from "Source format" to break the inheritance of
date formatting.
o Select your preferred format for your x-axis years.
o Copy the chart into your other application to test.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
