Help to update data in chart

sksanjeev786

Board Regular
Joined
Aug 5, 2020
Messages
210
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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
ABCDE
1ABCDE
287%84%86%86%81%
350%49%50%54%48%
438%35%36%32%33%
59%14%9%10%17%
62%1%4%3%1%
71%1%2%1%1%
Sheet1


Thanks in advance.
Regards,
Sajeev
 

Attachments

  • 01 Chart_.png
    01 Chart_.png
    11.6 KB · Views: 4

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

sksanjeev786

Board Regular
Joined
Aug 5, 2020
Messages
210
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi Team,

Anyone can help with the above query.
 

sksanjeev786

Board Regular
Joined
Aug 5, 2020
Messages
210
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi Team,

Anyone can help me on the above query.

Thanks.
Regards,
Sanjeev
 

CsJHUN

Active Member
Joined
Jan 13, 2015
Messages
356
Office Version
  1. 2016
Platform
  1. Windows
Hi, not a macro, but a workaround with conditional formating:
Munkafüzet1
ABCDEF
1ABCDE
2Top 2 boksz87%84%86%86%81%
3Agree strongly50%49%50%54%48%
4Agree slightly38%35%36%32%33%
5Mid9%14%9%10%17%
6DA slight2%1%4%3%1%
7DA strong1%1%2%1%1%
Munka1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B2:F7Other TypeDataBarNO

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

Board Regular
Joined
Aug 5, 2020
Messages
210
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi, not a macro, but a workaround with conditional formating:
Munkafüzet1
ABCDEF
1ABCDE
2Top 2 boksz87%84%86%86%81%
3Agree strongly50%49%50%54%48%
4Agree slightly38%35%36%32%33%
5Mid9%14%9%10%17%
6DA slight2%1%4%3%1%
7DA strong1%1%2%1%1%
Munka1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B2:F7Other TypeDataBarNO

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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,017
Messages
5,599,359
Members
414,306
Latest member
Dennis_vdw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top