Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

adding data markers to a bar chart

Posted by Joe on October 12, 2001 6:00 AM

Hi there, I have a 3d bar chart I am working on and need to add a small arrow or marker that is linked to the spreadsheet, and indicates the optimum level that data should be at. ie. if the value in the spreadsheet is changed, then the chart will also change. I can put in markers using Wordart, but cant link them to the spreadsheet.
If you can help, then thanks very much indeed!
Joe.

Re: adding data markers to a bar chart

Posted by Dan on October 12, 2001 8:03 AM

Sounds like that you want to attach a macro to the picture object? If you want to send me a copy of the workbook and what you are trying to do, I can see if I can make it work.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.