x axis

Hello, I'm having trouble with excel 2007 plotting my maximum date/time on the x axis properly. I have set the maximum value as 40155.08333 (12/8/09 02:00); however, the maximum value keeps plotting as about 40155.2 (12/8/09 04:45 ish). I am thoroughly stumped. Ancillary information: The x...

Hi I'm trying to use a cell reference value in the X Axis labels of Chart. For example the static axis labels reference would be =Student!$B$26:$R$26 However instead of it being $B$26, I need it to be $B with whatever Row number my named range "ColumnNumber" returns. Many thanks Ronan

Good Morning all Hopefully just a quick one, so to speak: Is it possible to have 2 X Axis on a bar chart? for example the X axis would be Mon Tue Wed Thur Fri Mon Tue Wed Thur Fri but the first set would be week 1 and the second set week 2. I have a table that lists the days and also has...

I created a bar chart for student test scores. The chart has the names of the students on the X axis and the score of each student on the Y axis. The problem I am having is that Excel can not fit all the student names on the X axis (only 30 names show up). I tried to decrease the font size of...

Hi there, I have a series of data: in row 1 I have price data (which I want on the y axis), in row 2 I have years (which I want on the x axis). The time periods will vary from 1-100. I am trying to create a graph that will change the length of the x-axis depending on the number of entries...