A Mekko Graphics user submitted this request to Ask an Expert.
When I make a line chart with a lot of data points, how do I only show a subset of data labels on the x axis? A common example of this is daily stock prices.
In this video, I demonstrate how to create a daily stock price line chart. I show how to show all of the data but only some of the X axis labels. Under Bars and Series in the Mekko Graphics ribbon, you can select a value for skipping labels under the Show Every Nth Bar option.
I also share how to reduce the numbers of series you show on a chart and how to combine small series into an Other series to improve readability. This video gives you a range of options for dealing with more data that you can cleanly show on a single chart.