Help with Graphs!

[Guest]

This is a two part question:

1. I have thousands of rows of dynamic data that look like the following:

jan feb march
Name1 type1 3 2
type2 1 5
type3 2 10
Name2 type1 3 5
type2 7 2
type3 6 4

Is there a fast way to produce many graphs that pull the graph title from the dynamic names (name1 name2 etc..) and have a pulldown menu for a user to choose which type to view somewhere in or near the graph?


2. Also, i need to make hyperlinks to these many graphs on one page, but I'm having trouble linking to a chart itself... Do I have to link to the cell that is near the chart? And how do I get the hyperlink to snap to the part of the page that contains the specified chart/cell instead of just snapping to the top of the sheet that contains the specified chart?

any help is greatly appreciated.
thanks!

 

[Landxlii]

Create pivot table of your data:

Pivot1 Pivot2 jan feb march
Name1 type1 3 2
Name1 type2 1 5
Name1 type3 2 10
Name2 type1 3 5
Name2 type2 7 2
Name2 type3 6 4

Pivot 1 and 2 have drop down arrows in the pivot table.
After choosing name and type, one line should remian in pivot table.
Result should look like:
Name x | Type x | 9 | 9 | 9 |

Now create a graph over that one line pivot table result.

This is a two part question:

1. I have thousands of rows of dynamic data that look like the following:

jan feb march
Name1 type1 3 2
type2 1 5
type3 2 10
Name2 type1 3 5
type2 7 2
type3 6 4

Is there a fast way to produce many graphs that pull the graph title from

the dynamic names (name1 name2 etc..) and have a pulldown menu for a user to
choose which type to view somewhere in or near the graph?

2. Also, i need to make hyperlinks to these many graphs on one page, but

I'm having trouble linking to a chart itself... Do I have to link to the
cell that is near the chart? And how do I get the hyperlink to snap to the
part of the page that contains the specified chart/cell instead of just
snapping to the top of the sheet that contains the specified chart?