Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Return value of a point in a bar chart
anyone know how to set the value of a variable to the value of a point in a chart. this dosen't work but I'm looking for something like this: x = ActiveChart.SeriesCollection(1).Points(6).Value -- Eric_B ------------------------------------------------------------------------ Eric_B's Profile: http://www.excelforum.com/member.php...o&userid=24486 View this thread: http://www.excelforum.com/showthread...hreadid=529676 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Return value of a point in a bar chart
Sub One()
MsgBox WorksheetFunction.Index(ActiveChart.SeriesCollecti on(1).Values, 6) End Sub Sub Two() Dim v As Variant v = ActiveChart.SeriesCollection(1).Values MsgBox v(6) End Sub - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Eric_B" wrote in message ... anyone know how to set the value of a variable to the value of a point in a chart. this dosen't work but I'm looking for something like this: x = ActiveChart.SeriesCollection(1).Points(6).Value -- Eric_B ------------------------------------------------------------------------ Eric_B's Profile: http://www.excelforum.com/member.php...o&userid=24486 View this thread: http://www.excelforum.com/showthread...hreadid=529676 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Return value of a point in a bar chart
Thank you Mr Peltier, this is exaclty what i was looking for -- Eric_B ------------------------------------------------------------------------ Eric_B's Profile: http://www.excelforum.com/member.php...o&userid=24486 View this thread: http://www.excelforum.com/showthread...hreadid=529676 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Chart | Charts and Charting in Excel | |||
how can I limit my chart | Charts and Charting in Excel | |||
Chart Property Confusion | Charts and Charting in Excel | |||
How to extend a single point into a line in a chart? | Charts and Charting in Excel | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel |