Adjusting one chart changes another 1

[deante]

I have a data set that is linked to a group of charts. I would like to be able to adjust one chart and change another. Everyting adds up to a certain number. Lets say the number is 200 widgets and my data set contains

50 widget 1 which is 25% of the total widgets
60 widget 2 which is 30% of the total widgets
40 widget 3 which is 20% of the total widgets
50 widget 4 which is 25% of the total widgets

I would like to click on one chart and change the rest of the charts. For example if I change widget 1 to 65 widgets (instead of 50), I would like the charts, and data set to change to,

65 widget 1 which is 32.5% of the total widgets
54 widget 2 which is 27% of the total widgets
45 widget 3 which is 22.5% of the total widgets
36 widget 4 which is 18% of the total widgets

I dont know if its even possible, but your help would be greatly appeciated.

Thanks in Advance

DeAnte

 

[GlennUK]

Changing a chart will automatically change the supporting data, and therefore any other charts created from that data. You question does not appear to refer to that ... it seems you want the total to always add up to 200 even if you adjust one value .... is that the case?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

Hi,

I don't understand how you are clicking on a chart and as a result of that, changing Source Data? That just does not happen!

However, any time Source Data changes, any chart that is linked to that data will also change.



Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[GlennUK]

Skip,

I have been watching people drag points on charts to alter Source Data for years .... haven't you ever tried it :-D

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

REALLY? I never saw that!

Learn sumthin' ev'r' day! THANX! ==> *

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[GlennUK]

It's not often I get to teach you sumthin' Skip. :-D Thanks for the *.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

That's one of the things that's GREAT about this site!

I'm still learning good stuff!

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[deante]

Yes that is the case. I would like the value to always equal 200. Do you have any suggestions?

 

[SkipVought]

Does each chart have a DIFFERENT source data range?

From what you originally stated, "I have a data set that is linked to a group of charts."

If the source data is changed, then any other chart that is linked to that value will also change.

I don't understand your question.



Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[deante]

They all have the same data range, however if I want to change one chart, I have to manually change the rest of the charts to maintain consistancy (maintain of total of 200). I would like to change all of the charts when I change just one of them.

I hope this clears this up.

Thanks for your help,

DeAnte

 

[SkipVought]

How do your charts reference the source data range?

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]