Re: MSGraph Bars not drawing in right proportion

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
news:ONWCc85aGHA.4972@xxxxxxxxxxxxxxxxxxxxxxx
I just opened a graph in design view of a report and was able to
right-click
the Y axis and manually set Scale.
--
Duane Hookom
MS Access MVP

"Alan Z. Scharf" <ascharf@xxxxxxxxxxxxxx> wrote in message
news:umlOAd2aGHA.3328@xxxxxxxxxxxxxxxxxxxxxxx
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" <DuaneAtNoSpanHookomDotNet> wrote in message
news:eO#SfhwaGHA.3328@xxxxxxxxxxxxxxxxxxxxxxx
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.
--
Duane Hookom
MS Access MVP

"Alan Z. Scharf" <ascharf@xxxxxxxxxxxxxx> wrote in message
news:ejigt8saGHA.996@xxxxxxxxxxxxxxxxxxxxxxx
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" <DuaneAtNoSpanHookomDotNet> wrote in message
news:eI$IXUkaGHA.3524@xxxxxxxxxxxxxxxxxxxxxxx
Check the Y scale. Does it start from 0?
--
Duane Hookom
MS Access MVP

"Alan Z. Scharf" <ascharf@xxxxxxxxxxxxxx> wrote in message
news:eAZBrLjaGHA.5004@xxxxxxxxxxxxxxxxxxxxxxx
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


















.

Relevant Pages

  • Re: MSGraph Bars not drawing in right proportion
    ... The Y-axis appears to be the issue, ... I'm still not sure how to resolve it with MS Graph in Access. ... I did both these records in identical Excel Column graph. ... The data is linked to the bar charts with a select query. ...
    (microsoft.public.access.reports)
  • Getting rid of percentage sign in Y-Axis -Charts
    ... I'm trying to work on a bar ... graph, my Y-Axis is from 0 - 100, but I need to get rid of ...
    (microsoft.public.powerpoint)
  • Re: Trouble with Excel Stacking Bar Graphs
    ... going to "Source Data" and entering the data location for the series ... but I could not figure out how to tell excel which column ... "Column 2", and the data is in column 2 of the graph, but I want it to ... How can I control which bar in the bar ...
    (microsoft.public.excel.misc)
  • Re: Chart Help
    ... Each row corresponds to a column position. ... Jon Peltier, Microsoft Excel MVP ... Your graph is close to what I'm looking for but every column in your graph ... is a stacked bar graph. ...
    (microsoft.public.excel.charting)
  • Re: Trouble with Excel Stacking Bar Graphs
    ... When you add data to a column chart, the added data must have data for each ... Jon Peltier, Microsoft Excel MVP ... "Column 2", and the data is in column 2 of the graph, but I want it to ... How can I control which bar in the bar ...
    (microsoft.public.excel.misc)