"Appeal to authority" is a commonly employed fallacy used in advertising. An example of this is the toothpaste ad that claims "9 out of 10 dentists
recommend our brand." The audience is not shown any evidence that this particular product is better than any other, they are only told that
authority figures recommend it.
Likewise, stating that 97% of all climate scientists believe in anthropogenic climate change ("man made" climate change) is an appeal to authority. In this case, the data also points to this same conclusion; however, it is a fallacy to say that it is true just because the majority of scientists believe it.
While it is important to know that there is a consensus among those who study a topic professionally, just knowing that there is agreement doesn't tell
why or how this conclusion was reached. It is a good starting point to narrow searches down for more information, but nothing more. However, if
someone argues that "97% of all climate scientists believe in anthropogenic climate change because of analyses of temperature trends over the last 100 years from
across the entire planet" and then provide this data, that would not be an appeal to authority. There may be other fallacies with the argument (depending on the data and conclusions), but it wouldn't be this one.
*Note: Anthropogenic climate change is a very real problem. This was merely used as an example because it is a topic with a very high consensus.