Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
charts, data in arrays, can same be done for ErrorBar figures?
Hi folks,
I have some charting code in which the data for the chart is specified as a formula (eg =SERIES("firstData", {"NTC","11","12","13","14","15","21","22","23","24 ","25"}, {0,8,15,17,10,35,8,15,18,11,28},1)) Everything works well with the exception of the corresponding error bar data; I can find no way of receovering this from the worksheet, so the charts maintain this reference to a range. Has anyone devised a solution to this? It would make writing code to edit the data displayed by a chart much more straightforward. Thanks in advance for your every suggestion Matthew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO i CREATE 3 PIE CHARTS SIDE BY SIDE- FOR 3 SERIES OF FIGURES | Charts and Charting in Excel | |||
Change errorbar series data from vba | Excel Programming | |||
Using Arrays as source data for charts | Excel Programming | |||
Problem using arrays in Excel Charts from VBA | Excel Programming | |||
Making charts from arrays in VBA | Charts and Charting in Excel |