Axis problem

[Ganesh7299]

Hi All,

I am trying to created the graph where I want to hide some data series from given source which will not reflect in the graph.

e.g. In the attached file sheet 'GRAPH 1' row no 3 and 12 are hide and not reflecting in the graph

But in the second sheet 'GRAPH 2' if I hide any row then data series is going to blank and axis shows value.

e.g. In the attached file sheet 'GRAPH 2' row no 3, 11 and 22 are hide and axis reflecting in the graph

Can I hide axis in the sheet 'GRAPH 2' along with source data.

Thanks,
Ganesh.

[Andy Pope]

Change the horizontal axis type to Text rather than automatic, which is treating it as Date.

[Ganesh7299]

Thanks a ton..... its done...

Ganesh