Help to update data in chart

[sksanjeev786]

Hi Team,

Can we have a macro as I need to update data in the chart? please find the attached file. as I have 100 chart in PPT for ref i have just attached 1 file

Book11
	A	B	C	D	E
1	A	B	C	D	E
2	87%	84%	86%	86%	81%
3	50%	49%	50%	54%	48%
4	38%	35%	36%	32%	33%
5	9%	14%	9%	10%	17%
6	2%	1%	4%	3%	1%
7	1%	1%	2%	1%	1%
Sheet1

Thanks in advance.
Regards,
Sajeev

 

[sksanjeev786]

Hi Team,

Anyone can help with the above query.

 

[sksanjeev786]

Hi Team,

Anyone can help me on the above query.

Thanks.
Regards,
Sanjeev

 

[CsJHUN]

Hi, not a macro, but a workaround with conditional formating:

Munkafüzet1
	A	B	C	D	E	F
1		A	B	C	D	E
2	Top 2 boksz	87%	84%	86%	86%	81%
3	Agree strongly	50%	49%	50%	54%	48%
4	Agree slightly	38%	35%	36%	32%	33%
5	Mid	9%	14%	9%	10%	17%
6	DA slight	2%	1%	4%	3%	1%
7	DA strong	1%	1%	2%	1%	1%
Munka1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:F7	Other Type	DataBar		NO

Databar settings: Minimum: number, value 0; maximum: number value 1

if you made this to first sheet, copy the and paste format to next 99 sheet

 

[sksanjeev786]

Hi, not a macro, but a workaround with conditional formating:

Munkafüzet1
	A	B	C	D	E	F
1		A	B	C	D	E
2	Top 2 boksz	87%	84%	86%	86%	81%
3	Agree strongly	50%	49%	50%	54%	48%
4	Agree slightly	38%	35%	36%	32%	33%
5	Mid	9%	14%	9%	10%	17%
6	DA slight	2%	1%	4%	3%	1%
7	DA strong	1%	1%	2%	1%	1%
Munka1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:F7	Other Type	DataBar		NO

Databar settings: Minimum: number, value 0; maximum: number value 1

if you made this to first sheet, copy the and paste format to next 99 sheet

Hi Sir,

I don't need conditional formatting my requirement is like I have data in the excel sheet and I have to update data into the chart I have shown in the above Screenshot.

Thanks.
Regards,
Sanjeev