The problem with the data labels is that each label, from 1 to N, is
attached to a point from 1 to N. If you hide the data for point i, then what
was point i+1 is now point i. The label for point i+1 is still on point i+1,
it doesn't move to point i. You would need to rerun the labeling macro.

I just answered another post, describing how much I hate data tables. They
are inflexible, unformattable, and just an overall PITA. Why not use a spare
range of the worksheet, put into it the data you want to show, format it the
way you like, and display it next to the chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"AndreaB" wrote in message
...
Hello!

I know that many people have asked the question here, but I can't seem
to figure it out.

The data I use is a 'rolling' 12 month calendar (in my example below
they only want to see a rolling 7 quarters). I add annotations
currently with a textbox for specific months until that month 'rolls'
off my chart when the month's data is no longer displayed.

I have downloaded the free add-in for the XYCharting, but it doesn't
seem to work for me. When I hide the column with the data I no longer
want to display, the data label does not move as it is supposed to.

My other issue is this, I need to display the data table with my
numbers. I haven't been able to figure out how to display my hidden
line with my labels and not display this information in the data
table.

Does this make sense? If not, here is some data to show you what I am
working with. Also, I put my charts on one worksheet and keep my data
separate on another worksheet, in case that matters :)

Data Worksheet Information:
(floating timeline) Q1-06 Q2-06 Q3-06 Q4-06 Q1-07 Q2-07 Q3-07
Data displayed: 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
# Received 97 68 35 40 34 42 46
# Eligible 97 68 35 40 34 42 46

So my chart basically shows the % graphically and then my data table
displays my numbers. This chart needs to be dynamic as I add a
Quarter and 'hide' the column of the old quarter I no longer want to
display. For example, when I hide Q1-06 and add Q4-07 I need any
annotations I might have made on, let's say Q3-06 to move
automatically....

Thoughts or suggestions?? ~andrea :)