Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Set Minimum Y Axis Values annem Excel Worksheet Functions 3 November 21st 07 04:34 PM
Need PivotChart x axis to cross Y axis at minimum Y axis value Aaron Charts and Charting in Excel 1 August 17th 07 08:51 AM
dates as minimum axis values bmh3 Charts and Charting in Excel 1 May 25th 07 05:04 PM
Auto minimum on Y Axis mattjenkins Charts and Charting in Excel 4 July 5th 06 04:28 PM
Hiding Values Below Z Axis Minimum Value on Axis Charts TryingToExcel Charts and Charting in Excel 1 February 18th 05 03:55 AM


All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"