Hi

I have seen a sheet in a workbook that just contains buttons to run macro for
graphs. there we plenty and doubt if they were painstakenly recorded on by
one and then assigned a button.

Can anyone point me in the right direction if its possible to short cut, by
just changing ranges. All the graphs will be the same format


Thank in advance

Regards

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200701/1

Hi,

If I understand your question you would like to change the chart by pressing
a button on the spreadsheet.

If this is what you want it doesn't require a macro. Range name your
different data ranges for the diffierent charts. For example A2:B10 would be
California, C2:D10 would be Washington data.

Set up one data area for charting. In this area create formulas like:
=INDEX(INDIRECT($I$1),ROW(A1),COLUMN(A1))

In cell I1 add a data validation dropdown with the list option selected.
Have the list be a list of the range names of each of your data areas. Copy
this formula down as many rows as your data extends and over for as many
columns. In my example I copied it down 9 rows and over for 2 columns
because that is how large the data area A2:B10 is. When I pick a state from
the Data Validation drop down the chart area updates and the chart plotted
from that are changes.

--
Cheers,
Shane Devenshire


"BNT1 via OfficeKB.com" wrote:

Hi

I have seen a sheet in a workbook that just contains buttons to run macro for
graphs. there we plenty and doubt if they were painstakenly recorded on by
one and then assigned a button.

Can anyone point me in the right direction if its possible to short cut, by
just changing ranges. All the graphs will be the same format


Thank in advance

Regards

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200701/1

Thanks Shane, I have not egnored you reply, gust been trying to adapt my data
format to the explanation. I tried the define name approach, but when it come
to getting the graph for data that was not directly underneath each other, as
in Delivered + Late Deliveries, it didnt work
Let me explain

I have the folowing data

Wk1,wk2,w3,etc in cells b2,c2,d2
"Delivered " in A3
"Forecast " in a4
"Released" in A5
"Late Deliveries" in A6
the area b3:d6 is filled with values.

What I want to do, is allow the operator to choose the approriate wk value in
a graph form, for say Delivered vs Forecast, or Delivered vs. Late Deliveries.


Any help/direction appriciated?

regards

Brian

ShaneDevenshire wrote:
Hi,

If I understand your question you would like to change the chart by pressing
a button on the spreadsheet.

If this is what you want it doesn't require a macro. Range name your
different data ranges for the diffierent charts. For example A2:B10 would be
California, C2:D10 would be Washington data.

Set up one data area for charting. In this area create formulas like:
=INDEX(INDIRECT($I$1),ROW(A1),COLUMN(A1))

In cell I1 add a data validation dropdown with the list option selected.
Have the list be a list of the range names of each of your data areas. Copy
this formula down as many rows as your data extends and over for as many
columns. In my example I copied it down 9 rows and over for 2 columns
because that is how large the data area A2:B10 is. When I pick a state from
the Data Validation drop down the chart area updates and the chart plotted
from that are changes.

Hi

[quoted text clipped - 10 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200701/1

Something like this?

http://peltiertech.com/Excel/Charts/ChartByControl.html

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


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:6cc3c107e74cd@uwe...
Thanks Shane, I have not egnored you reply, gust been trying to adapt my
data
format to the explanation. I tried the define name approach, but when it
come
to getting the graph for data that was not directly underneath each other,
as
in Delivered + Late Deliveries, it didnt work
Let me explain

I have the folowing data

Wk1,wk2,w3,etc in cells b2,c2,d2
"Delivered " in A3
"Forecast " in a4
"Released" in A5
"Late Deliveries" in A6
the area b3:d6 is filled with values.

What I want to do, is allow the operator to choose the approriate wk value
in
a graph form, for say Delivered vs Forecast, or Delivered vs. Late
Deliveries.


Any help/direction appriciated?

regards

Brian

ShaneDevenshire wrote:
Hi,

If I understand your question you would like to change the chart by
pressing
a button on the spreadsheet.

If this is what you want it doesn't require a macro. Range name your
different data ranges for the diffierent charts. For example A2:B10 would
be
California, C2:D10 would be Washington data.

Set up one data area for charting. In this area create formulas like:
=INDEX(INDIRECT($I$1),ROW(A1),COLUMN(A1))

In cell I1 add a data validation dropdown with the list option selected.
Have the list be a list of the range names of each of your data areas.
Copy
this formula down as many rows as your data extends and over for as many
columns. In my example I copied it down 9 rows and over for 2 columns
because that is how large the data area A2:B10 is. When I pick a state
from
the Data Validation drop down the chart area updates and the chart plotted
from that are changes.

Hi

[quoted text clipped - 10 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200701/1

Hi jon

Yes, have previously visited your site and have duplicated your example,
however, don't know how to show adjust your settings to unable graph to show
two bars per week

week numbers running along the row (row 5)
Forecast,Releases, Delivery, running down in column A

wishing the operator to select select 4 weeks of data, showing Forecast
verses Released. Which should show two vertical bars per week?

I thought Shane's approach was going to work, but could not adapt formula to
my layout of data

Appriciate you patience

regards



Jon Peltier wrote:
Something like this?

http://peltiertech.com/Excel/Charts/ChartByControl.html

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

Thanks Shane, I have not egnored you reply, gust been trying to adapt my
data
[quoted text clipped - 54 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200701/1

I show how to use sliders to adjust a date range he

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

If the two series are always Forecast and Release, you don't need any other
controls.

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


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:6cce18e52ebd4@uwe...
Hi jon

Yes, have previously visited your site and have duplicated your example,
however, don't know how to show adjust your settings to unable graph to
show
two bars per week

week numbers running along the row (row 5)
Forecast,Releases, Delivery, running down in column A

wishing the operator to select select 4 weeks of data, showing Forecast
verses Released. Which should show two vertical bars per week?

I thought Shane's approach was going to work, but could not adapt formula
to
my layout of data

Appriciate you patience

regards



Jon Peltier wrote:
Something like this?

http://peltiertech.com/Excel/Charts/ChartByControl.html

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

Thanks Shane, I have not egnored you reply, gust been trying to adapt my
data
[quoted text clipped - 54 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200701/1