B
BruceM
My data contains a category of machine part (gear, etc.) and a number,
expressed as a percentage:
Gear 95%
Spindle 90%
Is it possible to contrive a graph in Access (a vertical bar graph, for
instance) that shows the part type on the horizontal axis and the percentage
on the vertical axis? I can sort of get something that somewhat resembles
something close to what I want, except that the legend show the percentages,
and all parts that show 95% are the same color, while all parts that show
90% are a different color. Since Access charts are all but undocumented
(from what I can find after days of futile research), how does one learn how
to put them together? Is there documentation somewhere? The only
documentation I have seen tells me to select the category and the data
series and something or other, but not a word about what those things are.
I did manage to learn that in order to get a graph that shows from 0% to
100% I need to choose .9999 as the maximum value. If I choose 1 it assumes
I mean 1.2.
expressed as a percentage:
Gear 95%
Spindle 90%
Is it possible to contrive a graph in Access (a vertical bar graph, for
instance) that shows the part type on the horizontal axis and the percentage
on the vertical axis? I can sort of get something that somewhat resembles
something close to what I want, except that the legend show the percentages,
and all parts that show 95% are the same color, while all parts that show
90% are a different color. Since Access charts are all but undocumented
(from what I can find after days of futile research), how does one learn how
to put them together? Is there documentation somewhere? The only
documentation I have seen tells me to select the category and the data
series and something or other, but not a word about what those things are.
I did manage to learn that in order to get a graph that shows from 0% to
100% I need to choose .9999 as the maximum value. If I choose 1 it assumes
I mean 1.2.