| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
chart source data code
I am trying to select a range for chart data. Can someone enlighten me why
the following line does not work: ActiveChart.SeriesCollection(1).XValues = _ Sheets("8 count noif ").Range(Cells(5, 11), Cells(12, 11)) Thank you! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
chart source data code
Try this -
With Sheets("8 count noif ") ActiveChart.SeriesCollection(1).XValues = _ ..Range(.Cells(5, 11), .Cells(12, 11)) End With Strange spelling for a sheet name with the trailing space, but it seems to work OK Regards, Peter T "Knox" wrote in message ... I am trying to select a range for chart data. Can someone enlighten me why the following line does not work: ActiveChart.SeriesCollection(1).XValues = _ Sheets("8 count noif ").Range(Cells(5, 11), Cells(12, 11)) Thank you! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
chart source data code
it worked, you are the man!
"Peter T" wrote: Try this - With Sheets("8 count noif ") ActiveChart.SeriesCollection(1).XValues = _ ..Range(.Cells(5, 11), .Cells(12, 11)) End With Strange spelling for a sheet name with the trailing space, but it seems to work OK Regards, Peter T "Knox" wrote in message ... I am trying to select a range for chart data. Can someone enlighten me why the following line does not work: ActiveChart.SeriesCollection(1).XValues = _ Sheets("8 count noif ").Range(Cells(5, 11), Cells(12, 11)) Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pie chart & column chart w/same source data | Charts and Charting in Excel | |||
| How do I view and edit the source code for a Chart in Excel 2003? | Charts and Charting in Excel | |||
| How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
| Clumsy VBA Code for Chart Source Data from Loop | Excel Programming | |||
| Changing a chart source data in code. | Excel Programming | |||
Linear Mode
