OssieMac,
Thanks for the reply! What I am after is a very simple side by side bar
chart that shows a single bar for an individual employees % rating next to a
bar for the global employee average. I am not sure how to post an example,
but the spread sheet that I am pulling data from is also very simple. It has
a column of employee names followed by a column for their % values on
corresponding rows. The global average data is calculated as the last row or
data.
Thanks again,
HobieJuan

"OssieMac" wrote:

Need a bit more info. Can you post a sample of the data you have including
column headers etc?
What sort of chart do you want?
Do you need to be able to view all or multiple charts simultaneously. Under
some circumstances using AutoFilter allows you to create just one chart and
it becomes dynamic based on the AutoFilter setting.
If AutoFilter option used, do you have a column with unique values or titles
that would allow selection of a specific line of data. Alternatively would it
be out of the question to add a column and simply number from 1 to 150 and
use that to select the individual rows.
It is fairly simple then to write code to set the Autofilter and print each
chart if required.


--
Regards,

OssieMac