MSGraph Bars not drawing in right proportion

[Alan Z. Scharf]

Hi,

I have simple 3-d bar graphs comparing two numbers, e.g. 3.4 vs. 3.8%.

The underlying table data is one record with Stock Symbol, Value1, Value2,
e.g.

IBM 3.4 3.8

The data is linked to the bar charts with a select query.

The 3.4% bar is half the hieght of the 3.8% bar, whereas it should be only
slightly less high.

This is only happeninng on a couple of these bar graphs out of about 30
different records.

For all other records, graphs are drawing properly, e.g. 2% vs 4% shows a
barchart with the 2% bar half the height of the 4% bar.

Can anyone think of why this disproportionate rendering would occur for only
a couple records?

Any way to work around this?



Thanks.

Alan

 

[Duane Hookom]

Check the Y scale. Does it start from 0?

 

[Alan Z. Scharf]

Duane,

Thanks very much for your reply.

The Y-axis appears to be the issue, per your suspicion.

However, I'm still not sure how to resolve it with MS Graph in Access.

I did this same graph in Excel, and results are the same. That's how I
confirmed Y-axis is at issue.

More Detailed Facts.
---------------------
1. First, I misspoke. It is a Column graph, not bar - Chart Type Column,
second row, left column..

It is two side-by-side Columns, with each Column supposed to represent its
height in direct proportion to the single value of each column.

2. In my database, the record preceding the problem and the problem record
are as follows:

GE -0.038 -0.051 Draws OK
IBM -0.034 -0.038 Disproportionate

3. I did both these records in identical Excel Column graph.

GE record automatically sets Y-axis scale at Max = 0, Min = -.05.
IBM record automatically sets scale at MAX = -0.032, MIN = -.039 -
apparently same as is happepning in MS Graph in Access!!!

4. CONCLUSION: Something about particular data set in question is
automatically setting initial MAX value to -0.032, just above actual data
value, instead of Zero. Verifies your suspicion.

There are only two records out of 30 where this is happening. I don't see
any particular patter in data that would cause this. Besides, same thing
happening in Excel with these values!


5. QUESTION:
----------------
How can I resolve this in Access report with MS Graph using query of all
records?

In Excel, there is specific Scale tab available for Y-axis in Column chart.

However, there does not seem to be a Scale tab available for the same Column
graph in an MS Graph on Access report.

Hence, I'm not sure I can even reset the scale to Zero programmatically.

Is there some way to trick it by having the data in another form in the
query? The data has to display with a Percent sign.

Thanks very much for any insight you can give me.

Regards,

Alan

 

[Duane Hookom]

I think it's possible to change the Y scale in an Access graph from
automatic to manual and then set the values for min and max.

 

[Alan Z. Scharf]

Duane,

Thanks for your reply.

In this case, I don't see menu options to set the y-scale for the bar graph.

It IS available for sametype of graph in Excel chart options, buut not in
MSGraph chart options in Access.

I'll have to check further, but I haven't had any trouble finding setting
for other types of graphs.

Alan

 

[Duane Hookom]

I just opened a graph in design view of a report and was able to right-click
the Y axis and manually set Scale.

 

[Alan Z. Scharf]

Duane,

I found it.

I had already cleared the walls and Y-axis, so there was no y-axis to click
on to get to the scale tab! That's why I couldn't find it.

Thanks very much for your help. You solved my problem.

Regards,

Alan