Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
new excel vba functionality
this will probably never get considered or even read, but i'll try anyway. I've been developing solutions in Excel for a long time and i love everything about it. but one of the things i've run into several times is the issue of conditional chart formatting. there are a million ways to do this, but i think maybe if some MVP out there could drop Microsoft a line with my suggestion, it would help at least me out tremenously. my suggestion is simply this: i think there should be a way to programmatically reference specific series points on the chart. that way you could write VBA code like: If myChart.SeriesPoint(1) myChart.SeriesPoint(2) Then myChart.Trendlines(1).Color = Red End If this may be possible with Visual Studio Tools for Office, but i've never gotten to touch that yet. any advice welcome. -- medicenpringles ------------------------------------------------------------------------ medicenpringles's Profile: http://www.excelforum.com/member.php...o&userid=16458 View this thread: http://www.excelforum.com/showthread...hreadid=488827 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost arrow functionality within Excel | Excel Discussion (Misc queries) | |||
form with excel and word functionality | Excel Discussion (Misc queries) | |||
OS Version impact on Excel functionality | Excel Worksheet Functions | |||
Template functionality in Excel | Excel Discussion (Misc queries) | |||
Easiest way to add functionality to ALL Excel spreadsheets | Excel Programming |