Excel 2007 : Chart X-Axis automatically resizing upon adding additional values

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

Hi haidenai
Welcome to the forum
This site has a very good example of the dummy series needed to size the chart
http://spreadsheet-toolbox.com/libra...ith-quadrants/

Hello Haide,

it might be a good idea to post an Excel workbook instead of a picture.

In general, you can set the maximum and minimum values of any chart axis in the Format dialog for the axis.

If you do not want to do this manually, you can use VBA macros to ensure the min and max values for your charts.

Again, this will be easier to solve if you attach a file with some sample data and some charts, instead of a picture. Click "Go Advanced" below and then the paper clip icon to attach a file.

cheers,

looking at the image it would appear the length of the legend text has caused the plotarea to re position itself.

Try placing the legend at the bottom of the chart or if you only have 1 series removing it completely.