I have created a workbook which tracks lab data for a number of facilities.  
Sheet 1 holds all of my data, and Sheet 2 produces a report for each
facility.  The report for each facility is one page in length and contains a
table of the data, plus two charts.  There are about 300 ...

I have an area chart showing volume produce by a machine over time.
What I'd like is a visual indicator to show when the operator of the
machine changes.  In my spreadsheet I would have three columns.  Time,
volume, operator.

I have charted a couple of series in 100%stacked form.  I want the series
represended in the legend to match the order of the graphs.
ie
if the columns are red,green,blue I want the legend to have item 1 is red,

I have data that compares Bookings / Revenue and Cost.  Is it possible to
create a column chart that compares each category each month but the Cost bar
is a stacked column to show the different types of costs?
Thanks,

I'm needing to have my excel chart show me the percent change in my 2 series.
I would like this in a data label over series 2 on the chart, but all I can
figure out to do is have the value labeled.  Does any one have any
suggestions?  I'm believe I'm using Excel 2002.

I’m trying to merge to worksheets into one pivot chart. But i someho
don’t get to choose which fields I can put where in the table. If I us
the multiple consolidated option the wrong items are put on th
horizontal axis. What am i doing wrong

I'm constructing a line chart with six series and categorical values on the
x-axis.  I'm including y error bars that highly overlap and are very
difficult to read b/c all points within a given category are automatically
stacked vertically on top of one another.  Is there a way to ...

I would like to be able to tell if a cell is being used in any graph in my
workbook.  The standard <Audit> <Show dependants> does not seem to concider
Graphs as dependents (Help specifically talks about dependent "cells" in the
auditing write up)

I have successfully added a series to a chart, using the secondary axis.  
When adding another series to the chart, Excel uses the Primary axis as
default to load the series.  I want to change the Primary axis to Secondary
axis, but Excel does not allow that option - both options ...

Does anyone know if there is a type of graph that allows you to plot by
x-value and y-value. Much like the coordinates on a maps.
The scatter chart allows you to plot by y-value, but the x-axis is by
catergory.

I have some data that I am trying to plot by year, without having to put in
the year. When I do the auto year set-up it seems like it binds the dataset
to the year 2000. When I try to change the scale I can no longer see the
data. What gives? I'm trying to plot taper of a part ...

Is there any way to have a bar chart and then have percentages to the side
of each pair of bars?  The first series of data I have is Sales and the
second series is A/R Collections.  I want to have the percentage of A/R
Collections to Sales appear next to each pair of bars, but I ...

Does anyone know how to change JUST the top surface colours of individual
slices please? I want to keep the sides of the slices a uniform colour but
show the top surfaces in different colors. I really need to achieve this
within excel itself.

I need to create an xy scatter graph with a third data value (temperature)
labeling each point (label can be either text or graphical).
Seems like this should be possible, even easy, but my extensive attempts
have all failed.  Does anyone know how to do this?

possible to have the above mentioned?..
for example I have 4 shops.... each shop has a Total Sales figure and
Total Cash Sales Figure...
Y axis would be the number.... X axis would be the month... Jan, Feb