Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing grouping in Excel I get "Cannot shift objects off sheet"? | Excel Discussion (Misc queries) | |||
arrows dont move objects inside graph (plot) area | Excel Discussion (Misc queries) | |||
How to Name Chart Objects | Excel Discussion (Misc queries) | |||
Grouping and Objects | Excel Discussion (Misc queries) | |||
Why can't I resize/move objects in XL XP chart? | Excel Discussion (Misc queries) |