![]() |
Getting the minimum value on the x axis automatically
Hi there
I am graphing times and dates with a stacked bar graph. The first value on each bar is the start date/time and the second bar is the difference from the first time. I make the first bar invisible and what I end up with is a nice little bar going from start time to finish time. The problem I have is that the start time of say midnight 1/1/08 is 39448. So my graph which is hours wide is a tiny blip at the right hand end. The x axis config only lets me set auto (which seems to be 0), or a constant that I need to type in. I just want the minimum to be the lowest value on my chart. Is there a way to do this? I really need it! Regards Mark Dutton |
All times are GMT +1. The time now is 07:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com