Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

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

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 ...
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 ...
How to Create and Manage a Chart in Excel
In this tutorial I am going to introduce you to creating and managing charts in Excel. Before you create a chart yo ...
Update, Change, and Manage the Data Used in a Chart in Excel
In this tutorial I am going to show you how to update, change and manage the data used by charts in Excel. This tut ...

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 have a workbook with about 60 tabs - 1 data tab, and the 59 others are graphs. Is there a way to set the y-axis scale on each one without setting the scale on each one individually? (i.e. set a workbook scale for charts of 50-200)


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!

If I have an excel chart that has x and y point sets and the dimensions of these are in inches, how can I plot this onto paper where 1" on paper = 1" in the data - basically I just want to print to scale.

My only thought is to import it into AutoCAD and scale it there, any suggestions would be appreciated, thanks.


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 a large workbook with many charts. These charts all have the same scale but I need to have the capability to change the scale on these charts across the entire workbook. Coding this was not difficult and works correctly on charts that do not have data labels.

On charts with data labels the chart scales but the data labels are no longer displayed (see screenshots). The level that the bar chart portion of the chart was initially at is shifted lower when the scale is modified as well, this can also be seen in the screenshots.

I think there must be a property that I am missing. Something that will allow me to force the data labels back to their initial settings or maybe it is a property of the chart itself, I just cannot find what I need. Perhaps the scaling could be done differently as well.

Any help would be greatly appreciated!

This is the code used to scale the charts:

With chtobj.Chart.Axes(xlValue)
.MinimumScale = minScale
.MaximumScale = maxScale
.MajorUnitIsAuto = False
.MajorUnit = majUnit
End With
With chtobj.Chart.Axes(xlValue, xlSecondary)
.MinimumScale = minScaleSecondary
.MaximumScale = maxScaleSecondary
.MajorUnitIsAuto = False
.MajorUnit = majUnitSecondary
End With

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!

Hi there. I've tried and searched the whole afternoon. Perhaps somebody can help:
I'm trying to create a chart out of the following data:
User - Database

there are more than 10k users and 20K databases. users accessing 0 to n databases.
using the pivot function i can create charts showing how many databases a users accesses and how many users are accessing a specific database.

what i wanna do, is to group those countings and create charts like:
n users (y-scale=chart) are accessing 1 to 5 databases|6 to 10|11-20|>20 (x-scale)
n databases (y-scale=chart) are being accesses by 1 to 10 users|11 to 50|51 to 100|101 to 1000|>1000 (x-scale)

Is that possible and how?

thanks in advance

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.