Dynamic x-axis

Hi,

Please see my attached spreadsheet. I want x-axis to display data points with data only and it shouldn't display any blank cells. For example, in my sheet, the B column only have 24 values but the graph is showing 35 x-axis points. I need to hide all the empty ones dynamically. The data in my graph changes.

Thanks in advance.

If your data will always be sequential like the example, then all you need to do is change the formula on your Named series ChartLabels:

Please Login or Register  to view this content.

Thank you. It works.