Forum Discussion
Excel Chart - x axis won't automatically resize when there is no data to display
I'm charting very simple data from a set range - charting as a bar graph. This range will include blank/#N/A (I can adjust my formulas to whatever is needed) until new data comes in via formula...it's chronological so I have room for future dates' data.
I'm not able to create a chart that will ignore the currently empty future data. Instead it plots along the x axis leaving me with a condensed graph unnecessarily. Hoping this makes sense! I've tried things and have had no success.
I'm not able to create a chart that will ignore the currently empty future data. Instead it plots along the x axis leaving me with a condensed graph unnecessarily. Hoping this makes sense! I've tried things and have had no success.
13 Replies
- Since your range will include #N/A!.. I will suggest you deploy IFNA function to handle the error so that it doesn't impact your chart
Is there someone that can show me how to do this? I'm having no success working out how to automatically ignore for this graphing.
