[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