Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Positioning text Boxes on an excel chart
I have a line chart for 2 1/4 years of data.
The data looks like. (month, plot variable) Jan-04 45 Feb-04 53 Mar-04 20 ........ ....... Feb-06 34 What I want is a Band on the top that has the years corresponding to the month. In the data above, I'd have band across the entire chart with 3 values in it. Imaging 3 text boxes butting against each other and displaying the year. First text box would say 2004. Second box would say 2005 and the 3rd box would say 2006. Third text box would be 1/6th (2 months out of 12) of the 2004 and 2005 boxes. I'd like to automate this through vba. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text boxes in Excel 2003 chart won't print | Charts and Charting in Excel | |||
Text boxes disappear on Excel Chart | New Users to Excel | |||
Excel should default to autoformat for chart text boxes | Charts and Charting in Excel | |||
Recalculate sheet & Positioning text boxes | Excel Programming | |||
How do I copy an Excel chart with added text boxes into Word or P. | Charts and Charting in Excel |