![]() Knowing the exact values of the two measures is certainly one thing you are interested in. the country at bottom left with a relatively low fertility rate of ~2.5 and a life expectancy of only ~47 years? But what if you want to analyze the data in more detail and get some information about e.g. You now easily see the distribution of the data and the relationship between the two variables. Here is an XY Scatter chart comparing fertility rate (children per woman) and life expectancy in years of more than 200 countries in the year 2013 (data source: Gapminder): examine the maximums and minimums or the outliers. However, without further chart elements (like data labels) or interactive features (like tooltips), there is no way to easily explore and analyze the data in detail, e.g. This is especially the case on XY Scatter or Bubble charts with a lot of data points.Īn XY Scatter Chart is the perfect choice to display the relationship between two variables X and Y and the distribution of the data regarding these two measures. Tooltips are a very helpful feature for exploring and analyzing data. #ANYCHART SHARING TOOLTIP FOR FREE#Today’s post will discuss again Excel’s shortcomings in terms of chart tooltips, briefly describe 4 different techniques how to overcome this issue and – as always - provide the Microsoft Excel workbooks for free download. I already used and published this in several posts ( Another Technique for Interactive Excel Charts, Selecting and Highlighting Areas on Excel Charts, Select Areas on a USA Map in Microsoft Excel and Zooming in and out of Excel Charts), but this technique is also viable for implementing chart tooltips. Last, but not least, I discovered another approach for creating interactive charts in Excel. Next, reader Will Clark came up with the great idea of using a camera object instead of a simple textbox, in order to have more formatting options. Many people have asked for a simplified, generic template only providing the tooltips on a standard XY Scatter chart. Secondly, the workbook provided in 2010 implemented the better chart tooltips on another dashboard with additional features, which was published here: Bluffing Tableau Actions with Microsoft Excel. The problem of insufficient chart tooltips in Excel remains. Today, I would like to revisit this topic for several reasons:įirstly, Microsoft hasn’t done anything about this shortcoming in the versions 20. The post described the weaknesses of Microsoft Excel’s standard chart tooltips and provided a VBA-based technique how to get to customizable, meaningful and more useful tooltips in Excel. How to create customizable, meaningful tooltips on XY Scatter Charts in Microsoft Excelīack in December 2010, I published an article about Better Chart Tooltips with Microsoft Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |