![]() Then put the Needle on the secondary axis by clicking the box under the heading, Secondary Axis.įrom the needle column of the data table, the first number represents the proportional scale of 0-99 where you would like needle to land, and will be colored with No Fill. Select Chart Type dropdown and choose the first option under Pie, the donut green circle below. Select Chart Type dropdown and choose the fourth option under Pie, the donut red circle below. This can be performed in older versions and in an Apple environment by adapting the instructions.Ī combo graph is exactly as nameda combination of two graphs overlapping to present one image. Note that the directions below are designed for recent versions of Windows-based Excel. Older versions require you to graph both sets of data, then manually change one. Newer versions of Excel make this easy through the Combo Chart feature.
0 Comments
Leave a Reply. |