Chart visualisation - Hidden dates on X axis

[Villalobos]

Hello,

I would like to hidden dates on X axis in a chart. These dates has not got data in the source range.
Is it possible, if yes, could somebody offer a solution for that?

I have uploaded the sample file.

Thanks in advance!

 

[Luke M]

Right-click on x-axis, format axis. Under "Axis options, change the Axis type to be "Text axis". XL will stop interpreting the points as dates, and only show the dates that you have given it.

 

[Villalobos]

Hi Luke M,

Thanks this cool tip.

 

[Villalobos]

Hello Luke M,

I would like to ask one more.
How do you hidden the dates on X axis if your values are in a dynamic range and keeps on growing or shrinking?

 

[Luke M]

The dates are only hidden because you haven't listed them. If you want to keep adding to them, I suggest checking out Jon's article on dynamic charting to help you get started:
http://peltiertech.com/Excel/Charts/DynamicCharts.html
http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html

 

[Villalobos]

Thank you, those posts were very helpful for me.