Hello!
Im a student of economics in Vienna, and am currently working on my diploma's thesis.
Right now, I want to analyse my survey data, which consists of opinions to many different online community features.
All the opinions are in "Worksheet 1".
Each feature now has its own Worksheet, where data from "worksheet 1" is displayed.
It is collected via a series of relational functions, which depend on Cell A1.
If, for instance, I want to analyse the responses for "Forum", I simply type "Forum" into Cell A1 and it will get all the responses for "Forum".
I then copied this sheet, exchanged "Forum" for "Wiki" and so on....
My problem is now, that each sheet has a "scatter plot" chart on it, which charts one value only. (On the Worksheet "Forum" it only plots (X,Y) for "Forum")
Irrespective of the attribute (i.e Wiki, or Forum) it will always only chart values between 0 and 1 on both axis.
Now, for some strange reasons however, the X-axis always changes its length, when the word (Wiki, Forum etc..) changes.
I have already formatted both Axis as follows:
vertical axis cross: 0.0
min: 0
max: 1
major grid: 0.5
minor grid: 0.1
also, i have formatted Chart tools --> Format --> Size --> Properties --> "Don't move or resize cells"
Unfortunately the X-axis is still not locked, but changes depending on where the Datapoint of the attribute lies on the chart:
If X-Value > 0.5 then "Chart axis grows in length"
If X-Value < 0.5 then "Chart axis shrinks in length"
Could someone please tell me if there is a possibility to define an absolute chart size and axis-length?
Thanks a lot for your help in advance!
kind regards,
Haide
Bookmarks