| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Source data for chart
I have the following lines of code in a macro: ActiveSheet.ChartObjects("Prob").Activate ActiveChart.SeriesCollection(1).XValues = "=prob!R1C1:R45C1" ActiveChart.SeriesCollection(1).Values = "=prob!R1C2:R45C2" I want the number of chart data rows (in this example it is 45) to be variable so that this value is taken from a cell in the sheet, but it will not accept a variable name here. Is this possible? NSV -- nsv ------------------------------------------------------------------------ nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500 View this thread: http://www.excelforum.com/showthread...hreadid=487226 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Include info from data source in data table but not in chart | Charts and Charting in Excel | |||
| pie chart & column chart w/same source data | Charts and Charting in Excel | |||
| Excel chart source data y-values can only accept 7 data pts? | Charts and Charting in Excel | |||
| Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
| How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
![nsv[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
