Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Dynamically Linked Worksheet | Excel Worksheet Functions | |||
Creating a List of Loan Periods Dynamically | Excel Worksheet Functions | |||
Excel and Clinical Trials | Excel Discussion (Misc queries) | |||
Dynamically-linked formula, cell reference in the string | Excel Worksheet Functions | |||
creating a combobox dynamically on an excel sheet | New Users to Excel |