ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to ignore blank cels in x axis (https://www.excelbanter.com/charts-charting-excel/265405-how-ignore-blank-cels-x-axis.html)

titanium111

How to ignore blank cels in x axis
 
I would like to have a line chart that I change the x-axis values with an "if" statement.
Problem is number of x-axis values changes according to the selection (I want 12 periods of months or 8 Quarters according to the selection)
But I can not make my chart to ignore the last 4 blank cells automatically when I convert the the graph to Quarter view

Can anyone help?

Thanks


All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com