Change the colours of a Pie Chart to represent the data FIgures using VBA
50.7 هزار بار بازدید -
9 سال پیش
-
Hi Guys, In this quick
Hi Guys,
In this quick tutorial we are going to go through making a pie chart in Microsoft Excel show the colours that represent the data that they are displaying.
If you have a table that shows data for low risk (green), Medium Risk (orange) and high risk (red); you may wish to show the pie chart in the same colours as your table.
Excel can't do this as a standard, but with a little bit of VB code, we can get it to work.
Step One: Once you have your table of data and your pie chart. Press ALT and F11 to load the Visual Basics Editor.
Step Two: On the left you will see sheet 1, sheet 2 etc. Double click onto the sheet that you have the Pie Chart on.
Step Three: Paste the code from the video.
Step Four: Save the code and the spreadsheet. Close and reload.
Now it should be working.
PLEASE NOTE THAT THE DATA TABLE MUST CONTAIN THE COLOURS THAT YOU WISH TO BE DISPLAYED IN THE PIE CHART.
In this quick tutorial we are going to go through making a pie chart in Microsoft Excel show the colours that represent the data that they are displaying.
If you have a table that shows data for low risk (green), Medium Risk (orange) and high risk (red); you may wish to show the pie chart in the same colours as your table.
Excel can't do this as a standard, but with a little bit of VB code, we can get it to work.
Step One: Once you have your table of data and your pie chart. Press ALT and F11 to load the Visual Basics Editor.
Step Two: On the left you will see sheet 1, sheet 2 etc. Double click onto the sheet that you have the Pie Chart on.
Step Three: Paste the code from the video.
Step Four: Save the code and the spreadsheet. Close and reload.
Now it should be working.
PLEASE NOTE THAT THE DATA TABLE MUST CONTAIN THE COLOURS THAT YOU WISH TO BE DISPLAYED IN THE PIE CHART.
9 سال پیش
در تاریخ 1394/06/31 منتشر شده
است.
50,743
بـار بازدید شده