Prev: Conditional Formatting - Apply to Charts?
Next: Hiding Pie Slice When Value is Zero
From: Krys on 1 Jul 2008 13:46
Hi, since I got help on here last time, I was wondering if anyone could help
with this problem...

I have built a spreadsheet to show trends in our results. The macro runs
through selecting the relevant data, sorting then filtering it and then
building a graph to show the trends. As the number of results used in the
chart varies based on the dates entered (ie. between these two dates), the
macro selects an arbitrarily large column length for the data( eg. D2:E5000),
then uses Go To to reduce the selection to the last constant in the selected
area, then builds the chart from this selection. The macro does not seem to
recognise this though and will show the graph using values from D2:E15 as
this was the area selected in the building of the macro. What can I use in
the macro so size of the selection used is fluid and more or less values can
be shown in the chart?

Any help is greatly appreciated.
From: ShaneDevenshire on 1 Jul 2008 15:19
Hi,

Please show us the code:


--
Thanks,
Shane Devenshire


"Krys" wrote:

> Hi, since I got help on here last time, I was wondering if anyone could help
> with this problem...
>
> I have built a spreadsheet to show trends in our results. The macro runs
> through selecting the relevant data, sorting then filtering it and then
> building a graph to show the trends. As the number of results used in the
> chart varies based on the dates entered (ie. between these two dates), the
> macro selects an arbitrarily large column length for the data( eg. D2:E5000),
> then uses Go To to reduce the selection to the last constant in the selected
> area, then builds the chart from this selection. The macro does not seem to
> recognise this though and will show the graph using values from D2:E15 as
> this was the area selected in the building of the macro. What can I use in
> the macro so size of the selection used is fluid and more or less values can
> be shown in the chart?
>
> Any help is greatly appreciated.
From: Jon Peltier on 1 Jul 2008 15:19
You have to replace reference to "D2:E15" in the macro with a reference to
the range that you really want to use. You may have replaced a reference to
the selected range, then not changed the reference in Chart.SetSourceData.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Krys" <Krys(a)discussions.microsoft.com> wrote in message
news:03435027-F95B-4382-856A-C88D430B78F8(a)microsoft.com...
> Hi, since I got help on here last time, I was wondering if anyone could
> help
> with this problem...
>
> I have built a spreadsheet to show trends in our results. The macro runs
> through selecting the relevant data, sorting then filtering it and then
> building a graph to show the trends. As the number of results used in the
> chart varies based on the dates entered (ie. between these two dates), the
> macro selects an arbitrarily large column length for the data( eg.
> D2:E5000),
> then uses Go To to reduce the selection to the last constant in the
> selected
> area, then builds the chart from this selection. The macro does not seem
> to
> recognise this though and will show the graph using values from D2:E15 as
> this was the area selected in the building of the macro. What can I use in
> the macro so size of the selection used is fluid and more or less values
> can
> be shown in the chart?
>
> Any help is greatly appreciated.


 | 
Pages: 1
Prev: Conditional Formatting - Apply to Charts?
Next: Hiding Pie Slice When Value is Zero