If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automatically moving a drawing object in a chart
Anybody know how to automatically move a drawing object within a chart. When
I add new data the chart compresses to the left but the drawing objects stays. I want it to move with the bars or lines. Thanks, Dan |
#2
|
|||
|
|||
Automatically moving a drawing object in a chart
There's no Excel capability to automatically move a drawing object to keep
up with changing data (or changing chart formats, which can be just as frustrating). If the drawing object is not too complicated, you could add an XY series (one point only, an X and Y value) and use the drawing object as a custom marker. To do this, copy the object, select the series or the point, and paste. More info on custom chart markers: http://peltiertech.com/Excel/ChartsH...omMarkers.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Dan k" Dan wrote in message ... Anybody know how to automatically move a drawing object within a chart. When I add new data the chart compresses to the left but the drawing objects stays. I want it to move with the bars or lines. Thanks, Dan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Visio Shortcuts | [email protected] | Visio | 1 | December 28th, 2006 11:28 PM |
Can't save chart as object in current sheet | Ann Scharpf | Charts and Charting | 1 | December 3rd, 2004 11:24 PM |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |
Embed data in graph | wrace | Charts and Charting | 5 | May 5th, 2004 04:39 AM |
chartgroups,chartobjects etc-confusion to me | R.VENKATARAMAN | Charts and Charting | 1 | April 10th, 2004 04:09 PM |