T
tx12345
Hi,
It seems when a chart is created in Excel, even if you have '#N/A's i
the column, if you have 10 numbers plus, let's say 10 #N/As, you'll ge
a chart that shows 20 spaces worth of dta.
However, the source for the chart changes. One day is might be
=main!$G$8:$G$12, and the next =main!$G$8:$G$115, and the nex
=main!$G$8:$G$75, etc. I want to use the same chart, and not have an
extranneaous spce on the right. If thee are 10 entires, I only want t
see 10 entries on the chart, etc.
The only solution I have for the moment is very inelegant, which is t
create a chart each time with a macro using this code:
Code
-------------------
Dim w As String
w = Cells(6, 15)
Range(w).Select
Charts.Add
-------------------
where the macro reads from the little 'dim' statement on what range t
draw from to *create* the chart. But after fiddling around for a fe
hours, I could not figure out how to get the 'dim' statement t
*revise* the chart.
Any ideas?
TIA!!
It seems when a chart is created in Excel, even if you have '#N/A's i
the column, if you have 10 numbers plus, let's say 10 #N/As, you'll ge
a chart that shows 20 spaces worth of dta.
However, the source for the chart changes. One day is might be
=main!$G$8:$G$12, and the next =main!$G$8:$G$115, and the nex
=main!$G$8:$G$75, etc. I want to use the same chart, and not have an
extranneaous spce on the right. If thee are 10 entires, I only want t
see 10 entries on the chart, etc.
The only solution I have for the moment is very inelegant, which is t
create a chart each time with a macro using this code:
Code
-------------------
Dim w As String
w = Cells(6, 15)
Range(w).Select
Charts.Add
-------------------
where the macro reads from the little 'dim' statement on what range t
draw from to *create* the chart. But after fiddling around for a fe
hours, I could not figure out how to get the 'dim' statement t
*revise* the chart.
Any ideas?
TIA!!