![]() For this, select the needle and right click on it and then click on “Format Data Point”.Next, you need to make this needle bit out from the chart so that it can be identified easily.After this, you’ll only have the small part left in the pie chart which will be our needle for the SPEEDOMETER.Now, select both of the large data parts of the chart and apply no fill color to them to hide them.At this point, you have a chart like below. Note: If after selecting a pie chart if the angel is not correct (there is a chance) make sure to change it to 270.In “Change Chart Type” window, select pie chart for “Pointer” and click OK.After that, select the chart and go to Chart Tools ➜ Design Tabs ➜ Change Chart Type. ![]() In “Select Data Source” window click on “Add” to enter a new “Legend Entries” and select “Values” column from the third data table.For this, right click on the chart and then click on “Select data”. ![]() Now, the next thing is to create a pie chart with a third data table to add the needle. After this, you’ll have a chart like below.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |