Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Annotations sticking to data point & data table
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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
Formats and Data validations changes are not sticking | Excel Worksheet Functions | |||
Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
Including data in data table but not charting as a series or point | Charts and Charting in Excel | |||
Data "Point" in graph not matching table | Charts and Charting in Excel |