Home » Forums » Open Source Learning Center » Learning requests

Problem with graphs

Submitted by kariswong on 15 November, 2010 - 16:28

Hi there,

I am struggling to get the following issues fixed:

1. to ensure that the graphs align with the value table created; and

2. to ensure that the y axis showing the unit (£ - millions) used by value table and that align with the maximum and minimum values populated on the table.

It would be much appreciated if you could reply ASAP.

Many thanks and regards,

Karis

Graph Axis Problem
‹ formula for merging cells User Form - Copy Paste into text box ›
»

Graph Scale

Submitted by Anonymous on 16 November, 2010 - 09:49.

hi
This looks to be a problem with the scale of the Y axis.
- right click on the y axis
- choose Format Axis
- select the "Scale" option
- make sure the Auto options are clicked on

this will scale the axis to match the data.

»