Close Window   
Free Ebook
Got an Excel Question?
Ask it in our Excel forum!
Subscribe for Free Excel tips & more!

Time Scale Charts

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi is there a way to create a time scale chart measured in hours and minutes.
Help says only months and days but thought there might be a way around it


View Answers     

Similar Excel Tutorials

Change Axis Units on Charts in Excel
You can change the size of the units on a chart axis, their interval, where they start, where they finish, and mor ...
Change the Name of a Chart in Excel
How to change the name of a chart in Excel. This allows you to use a more intuitive chart reference when organizin ...
Scale Data for Printing in Excel - Fit more onto a Printed Page
This tip shows you how to fit more Excel data onto a page for printing. This does not change the size, shape, or lo ...
Changing Any Element in a Chart in Excel
In this tutorial I am going to go through the Layout tab in more detail and show you how to build up chart layouts ...

Helpful Excel Macros

Automatically Run a Macro so Many Seconds, Minutes, or Hours After an Excel Workbook has been Opened
- Run a macro after a certain amount of time has passed since the Excel workbook was opened. This means that you can set
Automatically Run a Macro at a Certain Time - i.e. Run a Macro at 4:30PM every day
- Automatically run an Excel macro at a certain time. This allows you to not have to worry about running a macro every da
Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Close a Workbook after a Time Limit is Reached
- This macro will automatically close the workbook in which it is located after that workbook has been opened for a certai
Get Values from a Chart
- This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s

Similar Topics

A few months back I created a set of charts to track defects over time. When I created the charts the date scale was set to match the frequency with which the data was pulled.

Soon after, however, I began noticing that even though the Autoformat option was turned off on both the Major and Minot unit, when I'd open the file to load in new data the date scale had been set to 79 days.

I've tried to just reset the scale, save and forget it, but the problem has continued and I'm at the point where I have to figure it out. Any ideas?

I am trying to create different charts using pivot chart option. For different catagories, the scale of the chart automatically changing. I want to fix the scale, so that I would be able to compare one category chart with other. Let me know how to fix the scale for pivot charts

So I have two sets of data- one from a pre-trial (measured over months) and one from a trial (measured over days). I would like to plot both on the same line chart. Both sets of data have the same y-axis scale. However, I would like to have the scale for the x-axis (time) split into two. I would like the pre-trial data to be in months, and then the trial data follow after in days. Is there anyway to split the x-axis into two different scales?

Can I get a charts scale to adjust to the numbers that I put in a cell with code?

The numbers can vary widely and I want the scale to be at least somewhat close to the numbers.

One time they can be 100 to 500 and the next time 2000 to 5000

If I use the scale of 100 to 500 the higher numbers will not even show and vise versa so I have to use many different charts with many differents scales.



I have 2 charts and I need Chart 2 to use the same Y scale as chart 1, it (Chart 1) will always be larger. The chart data will be changing depending on some user input.
So I need a way to find the maximum Y scale value of chart 1 and apply it to chart 2.
Anyone have any ideas?


Need some help to make a excelchart.
The point is that the chart shoult retrieve the x- and y plots from a table. x= time, Y= measured value, scale logarithmic. The problem is to make the time (x-axe) without fixed plot times. i.e data from time =10, time = 30, time = 40 and more should be written in the tabell be plotted with the y-koordinate. Must not be dependent on a plot each 30 minutes for instance.

- A table where I can plot the X and Y values. X = time in minutes staring from zero, Y = measured value.
- The chart should be logaritmic.
- When plotting the data in table the diagram should be drawn with a line between each plot.
- The timelength between each plot should not matter.

Appreciate any help, I'm a newbie at this so a good explaination had been nice

I create an excel bar chart for 27 locations showing one weeks worth of stats. Only 25 locations show on the chart no matter what I do. I can add more days of stats and the chart will scale, but no matter what I try (reselecting the locations), it only shows the first 25. I have looked through google, read articles, tried numerous settings. Nothing makes the data scale to the chart, nor does it extend to a second page. Why will more days make it scale, but it won't scale the locations. I've attached a sample of my chart..

I'm working with two excel charts that have dates along the x-axis. The first chart worked fine, as it allows me to change the max/min values in the scale tab, but if I pull up the Format Axis for the x-axis on the second chart (which has similar data), the only values I can input begin with "Value (Y) axis crosses at category number:" and continue...I don't have the option to adjust my max/min/scale values. Any ideas???

As usual...I solved the problem after posting...I changed the Chart options for Time-scale and it works...

I've been googling this to death with no results so I gave in and signed up here. It's so basic I am embarrassed but I can't get a jot of useful information from MS help or elsewhere. I would have thought this question would have come up before.

Anyway I'm using Windows Vista (still) and Excel 2007. All I want to do is plot some line charts of % mortality of insects for each treatment vs time. I have two treatments and a control so there should be three lines. That all works. However I have measured insect mortality % at 0 hours, 1 hour, 2 hours, 4 hours and 24 hours. When I draw the chart the x axis is scaled so that each time interval is the same. That is, one hour is the same as two hours and 20 hours. I also need the x and y axes to intersect at zero.

This is a sample of the data.

T0 T1 T2 T4 T24 Product A
0% 30% 85% 95% 100% Product B
0% 25% 73% 88% 100% CONTROL 0% 0% 0% 0% 0%
So it should show rapid changes in the first four hours then a nice line onto 24 hours some interval to the right. But instead it shows it all as though it is at one, two, three and four hours; i.e. equal time interval.

It seems very simple and I'm sure I've done it before with older versions of Excel but I'm sure you've heard enough ranting about Excel 2007 changes.

Looking forward to your advice. If this has been answered I apologise but please post a link. Thanks. I will return.


tried to be concise in the the title not sure if it makes sense!

anyway i'll try again.

i have attached a pic to show more clearly, i am outputting charts from vba and they are giving me a problem with the x-axis scale. all the months are fine except when i get to august - 08 it calls it july - 08.

when i hold the cursor over the data point it correctly says aug - 08 point, but on the axis and display it show july - 08, so 2 july - 08's next to each other. i have messed around with the code for hours to try to get it to change and its driving me mad as i have done so many charts and so much code i cant afford the time to go and start again (even though i know this would probably fix it, damn computers!). anyone seen it before or have any ideas on how to fix this?

any help much appreciated.


I'd like to use a logarithmic scale for one of my chart axes, but I want the axis to go from 1 to 1.1, rather than from 1 to 10, or 1 to 100, etc. Is there a way to do this? When I try entering "Minimum = 1, Maximum = 1.1" under the scale tab, the chart still displays a range from 1 to 10. Any help would be much appreciated!


how do i set up my charts so that the scale is automatically updated, as inputs change? for example, first inputs on the graph might require a scale up to $100,000.
as inputs change, the scale might be needed at say $500,000. i have to manually adjust the scale on each graph.

is there a way that i can set it up so that the scale will adjust dynamically on its own?

i remember finding a method here at mr excel, but can't find the thread that explains it...

any help is much appreciated, it is so tedious to have to adjust the scale on each graph every time we have a change in data....


Hi. I need some help on getting the time to show correctly on the X axis of my charts.

I want to create a chart for each 15 minute increment in the day for 22 days.

Example -

Chart 1 (x axis):
Mon 5 2 12:00 AM , Tue 5 3 12:00 AM , ... Tue 5 24 12:00 AM

Chart 2 (x axis):
Mon 5 2 12:15 AM , Tue 5 3 12:15 AM , ... Tue 5 24 12:15 AM

The problem is that on the second chart, the dates show up correctly, but the increment is supposed to be 12:15, and it still shows 12:00.

I thought the chart was trying to round down, but I experimented on higher intervals, and it still did the same thing. I'm thinking it might be a scale issue? I'm not too sure, so if you got any ideas on what I'm doing wrong, please let me know!


I googled around and used the excel help-function, but I must be using the wrong terms for I found nothing on this subject

I would like to put different data in one and the same graph. For example, I'm graphing costs against mont AND working hours. The costs are way, way more (in millions) than the working hours (in thousands).
With only one y-scale bar (left) such a graph might give you insight in the costs, but makes the differences in working hours unreadable as they're so low on the chart and seem to be at the same height all the time.

Is it possible in excel to have an y-scale (left) for series 1, and an y-scale (right) for series 2?

Or should I just make 2 transparent graphs and place them on top of one another?

Thanks in advance

I have some pivot tables from which I have to create chart. now the x axe of the chart has the date value. and I want to chage the scale as well as the format of the scalse. and also when the pivot table updates the minimum scale has to be the same as it is. Only the maximum scale will update.

I have attached here one snapshot. Please help in finding the solution for this as I am working on hundreds of like this and because of this I have to copy the pivot table and paste as value and then have to create regular chart. I want to remove these steps. Will appreciate your help.

Thank You

I have a spreadsheet that contain peoples hours on a daily basis under separate headings and I want to create a separate std column chart for each person that contains dates as the x axis with hours as the y axis. I am using hh:mm format to add the hours because I need a total number of hours for each day, with a total number of hours for each month further down the spreadsheet. However, the time slot is not quite I'm looking for. What I would like to do is see the time scale axis with major unit displayed as a whole hour, eg 01:00 to 15:00 depending on how many hours are completed each day. Currenty it jumps from 00:00 to 01:12 and so forth.

I have attached a copy of what I currently have as the chart.

Any help on how to change the scaling axis would be much appreciated.

Many thanks!

I am trying to replicate a written drivers log book hours by using an interactive graphic or chart that inputs the data and then using calculations check against driving hours rules to find instances where driving may have exceed allowable maximums
The image is the time scale as I am trying to replicate.

I've created several charts that track defects over time. The data is pulled periodically and when the chart was created I set the date scales to match the number of days in each period.

Soon after I began noticing though that even though the auto-scale option was turned off for the Major and Minor unit they would still be changed when I'd reopen the file to add new data.

I've tried to just reset the values, save, and forget about it, but this has been happening for several months now and my curiosity and level of annoyance have gotten to the point where I have to figure out the cause.

Has anyone else experienced something similar? Or know what the cause might be? Thanks for any help.

Hi, I created a chart with three separate series displaying values across three separate date ranges. Each of the three date ranges for each series reflect the fact the values were taken at intervals of one week and because of this, I set the chart to display an X axis scale with an interval of 7 days between mark.

My chart is using a continuous date range scale to bridge the gap in time between three phases of values and so it's leaving spaces between three separate series of values.
So what I want to know is if there is a way to make the X axis of a chart display a non-continuous date range across the chart. I'd like to keep the scale at intervals of 7 days where there are values in each data series but shorten or remove the gap in time between the three series. Is this possible?

I don't know if this is very clear and I have searched for an answer although I don't know if I'm using the best search terms. I found lots of answers for people having problems with charts displaying different things for cells with no value but this is not my problem.
I'd appreciate any help!
Many thanks,

hey guys - I've already created a Gantt Chat tool in excel which is basically just a stacked bar chart.

The issue that I'm having is setting the Y axis scale. All of the events take place over the time span of 36 hours, and I want 36 vertical tick marks, each representing one hour. I've gotten it to make 36 tick marks, however they reset at 24 because it thinks it's on a 24 hour time scale I believe. Instead of them counting up to 24 then resetting and counting to 12, I want them to simply count from 1-36.

Any suggestions?

I have kind of xy-chart.

Values on x and y varies a lot according to calculations so i would like to
fit them to my chart area.
But i would like to fit them so that x equals y, so the scale is 1:1.

- fit x according its max value (enabling 'max value' in chart)
- scale y so that 1:1 scale is achieved. (Here i can't use the 'max value'
in chart, because 1:1 scale can't be achieved)

What to do.

Thank You in advance.

I'm trying to create a stacked column chart, and I'm having trouble trying to get things to scale properly. My expensed, encumbered, and preencumbered amounts range from nothing to millions of dollars, and I have about 20 categories in my charts. To get them to show, reasonably, I want to use the logarithmic scale. However, my zero amounts mess that up, as Excel gives a messsage that I can't use zeros in a logarithmic scale. How would I get the chart to ignore my zero amounts, or how would I get my millions and my 1 and 2 cent amounts to coexist in the same chart otherwise? Any help is highly appreciated.


I am doing a surveying project for an engineering class I am taking.

Ideally I would use autocad for this but I have no idea how to use it.

What I have is x,y values for 99 points that I have measured.

I know the scatter chart will give me the dots in the location that I need but I need to scale it to 1"=30' on the printout.

Any ideas would be great. If not I have to do this by hand which wouldn't be fun.

Hi everyone,

I would like to create a timeseries chart with a double scale showing Q1 09, Q2 09, Q3 09, Q4 09, and then monthly for 2010. Is there a way to do this in excel, or is there a way to achieve double discretisation on the scale in a chart?

Thank you.


I am working on a report in Excel where we compare four models with eachother.
Therefore we use four charts which we place next to eachother. The data is
filled into the datasheet automatically from access through macro's.

The problem is that the scale of the x-axis differs on each chart while we
want the same scale on all four charts. Auto-scaling scales each chart
individually, so that is not an option as well.

The only solution what I can come up with is making a macro that searches
for the largest value in the datasheet and then setting the maximum of each
axis to that value.
This seems quite a lot of work, so my question is, is there any other way to
do this?