[AccessD] Graph Lines

Dan Waters dwaters at usinternet.com
Sat Dec 17 18:44:11 CST 2005


It sounds like the series number or the series order is changing when you
are requerying.  Try checking that each time you run your query and maybe
there will be a pattern you can work with.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Saturday, December 17, 2005 3:15 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Graph Lines

Dan,
Thanks for the quick response.
I have no trouble getting the right type of graph, just not consistently
getting the same column to be the line as opposed to the bar, when I feed
different data to the underlying table.
I probably am not explaining this well either.

Any help is welcome.

bob



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dan Waters
Sent: Saturday, December 17, 2005 12:34 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Graph Lines


Bob,

When the chart is in Design view, right-click anywhere on the chart and
select Chart Object | Edit.  Then right-click on the series that should be a
line and select Chart Type.  Then select the Line Type.

See - charts aren't really so bad!

(The above assumes you're using MS Graph within an Access report.)

Hope This Helps!
Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Saturday, December 17, 2005 2:02 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Graph Lines

Hello to the List,

Can anyone remember how to designate which data item will be the line on a
line-column chart which contains both multiple bars and a line?

So far I am getting different results when changing the data.

IOW, sometimes the "goals" are the line and other times they are a bar.


BTW, I hate doing graphs.

tia

bob heygood



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list