Grouping Objects in a Chart or Graph
 

I have a chart which displays a timeline for different events. In the chart
I have the data points labeled for each event. I also add a label, in the
format of a figure, for the value of the event. The data is linked to a
spreadsheet which can be changed by date. When I change the observation
period the data labes for the events moves according to the data in the
chart, but the values do not move. What I would like to do is group the data
label and values so I do not have to move these every time I look at new sets
of information.

Thanks

Grouping Objects in a Chart or Graph
 

Vito,

Right-click your chart, and select Source Data. Go to the Series tab. Examine the "Values"
box, and the "Category (X) axis labels" boxes.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com


-----------------------------------------------------------------------
"vito" wrote in message
...
I have a chart which displays a timeline for different events. In the chart
I have the data points labeled for each event. I also add a label, in the
format of a figure, for the value of the event. The data is linked to a
spreadsheet which can be changed by date. When I change the observation
period the data labes for the events moves according to the data in the
chart, but the values do not move. What I would like to do is group the data
label and values so I do not have to move these every time I look at new sets
of information.

Thanks