Groups | Search | Server Info | Login | Register

Groups > comp.databases.ms-access > #773

Re: Getting To A "Chart" Object From VBA?

Show all headers | View raw

Per David-W-Fenton:
>Where are you putting the code? Certain objects do not exist for
>certain events. In general, I wouldn't expect this kind of thing to
>work, since you can't do anything like this with subreports. 

Report_Open().

I want to beautify the graph in a manner that does not seem tb
supported by the UI.

Specifically, I want to replace the numbered tick marks on the
Y-axis with labels like "AAA", "AA", "AA-"... and so-forth.

The values determining the height of the bars are actually
numerical representations of security ratings.   2.75 = AAA, 2.5
= AA, 2.25 = AA- and so-forth.

But the user doesn't know from the numbers.   They are an
internal artifice used to create averages and weighted ratings.

All the user knows from are the alphabetic ratings like "AAA",
"AA", "AA-" and so-forth.
-- 
PeteCresswell

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Getting To A "Chart" Object From VBA? "(PeteCresswell)" <x@y.Invalid> - 2011-03-31 10:25 -0400
  Re: Getting To A "Chart" Object From VBA? "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-03-31 11:00 -0500
    Re: Getting To A "Chart" Object From VBA? "(PeteCresswell)" <x@y.Invalid> - 2011-03-31 13:01 -0400
      Re: Getting To A "Chart" Object From VBA? "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-03-31 12:14 -0500
        Re: Getting To A "Chart" Object From VBA? "(PeteCresswell)" <x@y.Invalid> - 2011-03-31 13:27 -0400
  Re: Getting To A "Chart" Object From VBA? "David-W-Fenton" <NoEmail@SeeSignature.invalid> - 2011-04-01 19:58 +0000
    Re: Getting To A "Chart" Object From VBA? "(PeteCresswell)" <x@y.Invalid> - 2011-04-02 18:50 -0400
      Re: Getting To A "Chart" Object From VBA? "David-W-Fenton" <NoEmail@SeeSignature.invalid> - 2011-04-03 15:35 +0000

csiph-web