Problem with bar chart with logarithmic axis

[ankit4035]

Hello all,

I am having a dataset with values ranging from 0 to 78 and many values less than 1.

snap1.JPG

I want to plot bar chart. Since, I have values with greater range, I opted for logarithmic axis. Also, since my data contains 0, I converted them to 0.000001 so that it can be plotted when using log scale. Also, I have changed minimum value in axis to 0.0001 so that 0 values won't be shown. My problem is that, all those values lesser than 1 are plotted in negative.

snap2.JPG

In the graph, I just want to change the axis to log and not the values. Something like this.

snap3.JPG

Any idea, how can I obtain such graphs in Excel.

Thanks.

[xlnitwit]

Hi,

You can set the options for the Y axis such that the X axis crosses at 0.00001 rather than the default 1.

[ankit4035]

Thanks a lot genius xlnitwit.... It was so easy and I was worried for days....Thanks again.