Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Source Data for the Chart
Hi All,
One Small Issue: I am drawing a chart and this is the source data for that. ActiveChart.SetSourceData Source:=Sheets("Analysis").Range("E1:E11,Y1:AJ11") _ , PlotBy:=xlRows Is there any way I can put a variable in place of 11 in the range. This variable will count the data in column E. Also, Column AJ is the extreme, I may not go upto that. Is there anyway I can make that as a variable also. This variable counts the data in Y1:AJ1 and goes only that many columns to the right of Y1 Let me know if you people can help with this Thanks, Anshuman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pie chart & column chart w/same source data | 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 | |||
Source data for a Chart | Excel Discussion (Misc queries) | |||
Pie chart source data | Charts and Charting in Excel |