Extracting data from spreadsheet to a graph

[Hankjam]

I would like to know how achieve this.

We have a data set that is 30 columns by 10's thousand rows.
The important columns for this excerise are:

Column A is date
Column B is ATP, either 10 or Km
Column C is enzyme
Co,umn F is Control counts

We have +300 enzymes.

I would like to have a graph that shows the Control counts v date for
each enzyme for either ATP concentration using a drop down for each. I
would prefer an XY graph.

I sort of got there with a Pivot table but it is not very pretty.

I was wondering if there was another way.

Many thanks for reading this far.

Hj

 

[Don Guillett]

I would like to know how achieve this.

We have a data set that is 30 columns by 10's thousand rows.
The important columns for this excerise are:

Column A is date
Column B is ATP, either 10 or Km
Column C is enzyme
Co,umn F is Control counts

We have +300 enzymes.

I would like to have a graph that shows the Control counts v date for
each enzyme for either ATP concentration using a drop down for each. I
would prefer an XY graph.

I sort of got there with a Pivot table but it is not very pretty.

I was wondering if there was another way.

Many thanks for reading this far.

Hj

I'm having a hard time figuring out what you want.

"If desired, send your file to dguillett1 @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."