Creating a dynamically-linked graph: trials.

Hi

I'm trying to make a chart in excel. I've dynamically linked the data to
some fields in a table in excell and I've filtered the data appropriately.

Had a look at a few tutes including microsofts very own (where everything
goes without a hitch!), still can't get anything resembling the sort of
chart that I want.

I'm sure I'm just neglecting to do something simple.

The y-axis should display two regions: Australia, and the rest of the
world. Each region should have three bars relating to the efficacy of our
advertising in various forms of print media: state newspapers, local
newspapers and flyers.

As the list of countries in the Access table is subject to potential
growth, I need the chart and it's corresponding data sheet to be flexible
enough to handle such changes without the need to mod any formulas. Also,
as more data comes in, there will be a corresponding growth in the number
of rows, this needs to be accomodated for, too.

I made an mspaint drawing of what I want my final chart to look like, if
anyone is interested in seeing it.

Regards


Adam
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Adam,

Sounds like a pivot graph would work for you - but you need to better describe your data set up to
get more detailed help.

HTH,
Bernie
MS Excel MVP


"yadang" wrote in message news
Hi

I'm trying to make a chart in excel. I've dynamically linked the data to some fields in a table
in excell and I've filtered the data appropriately.

Had a look at a few tutes including microsofts very own (where everything goes without a hitch!),
still can't get anything resembling the sort of chart that I want.

I'm sure I'm just neglecting to do something simple.

The y-axis should display two regions: Australia, and the rest of the world. Each region should
have three bars relating to the efficacy of our advertising in various forms of print media:
state newspapers, local newspapers and flyers.

As the list of countries in the Access table is subject to potential growth, I need the chart and
it's corresponding data sheet to be flexible enough to handle such changes without the need to
mod any formulas. Also, as more data comes in, there will be a corresponding growth in the
number of rows, this needs to be accomodated for, too.

I made an mspaint drawing of what I want my final chart to look like, if anyone is interested in
seeing it.

Regards


Adam
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Problem solved

Turns out I had misdiagnosed the problem to begin with. I had foolishly
assumed that the part of the formala that defined the range (d7:d17) would
not stretch (to, say for instance d7:d20) if i added more records.

In the course of adding more records, I found this to be the case
(happily).

Regards


Yadang

On Thu, 01 Oct 2009 03:25:25 +0800, yadang wrote:

Hi

I'm trying to make a chart in excel. I've dynamically linked the data
to some fields in a table in excell and I've filtered the data
appropriately.

Had a look at a few tutes including microsofts very own (where
everything goes without a hitch!), still can't get anything resembling
the sort of chart that I want.

I'm sure I'm just neglecting to do something simple.

The y-axis should display two regions: Australia, and the rest of the
world. Each region should have three bars relating to the efficacy of
our advertising in various forms of print media: state newspapers, local
newspapers and flyers.

As the list of countries in the Access table is subject to potential
growth, I need the chart and it's corresponding data sheet to be
flexible enough to handle such changes without the need to mod any
formulas. Also, as more data comes in, there will be a corresponding
growth in the number of rows, this needs to be accomodated for, too.

I made an mspaint drawing of what I want my final chart to look like, if
anyone is interested in seeing it.

Regards


Adam


--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/