Working with two charts

[LESLEY EDWARDS]

I am just learning about formulas and need some help. I don't know if this
is possible or not.
I have two worksheet tables in excel The first is a report that list
employees & the columns are: salaries, certification level, and # years
employed. The salary in this chart is manually entered based on a salary
scale.

The salary scale is the other table. The x axis is Certification level and y
axis is # years employed.
I want excel to take the certification level & # years columns in the first
worksheet and enter the salary from the salary scale chart.

Thanks for any help
DLE

 

[BruceP]

It sounds like the simplest way to do this is to forget for a momen
that you're working with charts. Just do your calculations, and pu
the results in their own column or row. Once you've got you
calculations right, building the chart through the chart wizard i
pretty easy