Hello-

Background Info:
I chart production data for new products as they come online. I have a
separate worksheet for each product with daily production information. On a
separate worksheet we will call "summary worksheet" I have columns for each
new product (B through Z), and 365 rows with the date on each (A2:A366). If
Product1 came online January 11, 2007, I went to cell B2 on the "summary
worksheet" and linked it's contents to the production data for that day in
the worksheet for Product1. The formula was copied down to the end of the
year to grab the production data as it is updated on the product's individual
worksheet. No problemo.

Problem:
My 2D Stacked Area chart on the summary worksheet. Visually the graph looks
correct - as new products come online a new stacked column is added.
However, when I hover my mouse over the data points, the wrong information is
shown. I'll hover over data that should be for November, and not only is the
value not showing up, but it claims my point is for January or April or some
other seemingly random and incorrect month. I want to see Series Product1,
Point November 14, Value 100.

Question 1: Do area charts not provide value information when you hover?
On a line graph that I have on the individual product worksheet I can get the
product name, date, and production value when I hover.

Question 2: I researched the forum and tried an XY plot already, but this
just puts all 25 of my products in lines on top of each other and you can't
see when each product starts and how it contributes to the "whole."

Hotmail is blocked from my websites so I can't be notified of responses, but
I can still access this forum and I'll check back very often.

Any help is appreciated.

-Amber