MS Excel / VBA help thread

This seems a bit complicated. I just want the units to be in increments of 1 hour not a random split.

So vertical axis 1, 2, 3, 4, 5, 6 hours.

Just do 1,2,3,4,5,6 then?

I'm not sure what the problem is with doing that.

When you click te chart design tab and select data, where does the vertical (legend entries) point to?
When you click on the chart, and do the format vertical axis, what format is it in?

I tried adding the 1,2 etc etc but it just point two data plots on the graph

1 Attachment

You should be able to set the intervals if you right click on them, go Format Axis, expand Tick Marks and adjust the Interval between Marks.

Whether it will actually work is obviously another thing.

Without being a pain in the arse, what are you trying to plot?

That just adds little marks along the y axis. I just want to edit the numbers so they go up in standard numbers not what it’s produced. I’ve tried messing with the units but it fucks up the whole graph

1 Attachment

Add a new column next to the current one being used for the y axis, use the formula =hour(original cell), then use that for the Y axis?

I must be explaining myself badly. Vertical axis is time in 1 hour increments and horizontal is days of the week. I’ll always have 5 bits of data (1 for each day) Monday to Friday. But I want to change the vertical axis numbers to a standard format of 1:00:00 up to 6:00:00. This must be quite simple but I’m not getting it. I’ve messed with the units to no avail.

It's because, see my first post, you need to use minutes/total minutes. because of excel and time

What you need to do is set the units (axis options) major as 1 hour. but excel doesn't like hours, so you have to use 0.041667 ish to get it to one hour

So
I've done this and it works
cell a11 = 1
a12 = a11+1
copy to a16

You now have 1 -6
in cells b 11 - 16 write = 60/1440
in cells c 11 - 16 write = a11 *b11

that will give you the range for your vertical axis.

So you go to your chart
click axis
click format
set the bounds to minimum = 0, maximum = 0.291669
set the units to
major = 0.041667
minor = 0.0083334

and you'll have a vertical axis of 0 - 7, with the intervals formatted as 1 hour.

Is your range of data always 1 - 6 hours?

anyone using an AI excel helper? been hearing good things but different add-ons available so unsure which to go with....

Alternatively you can set the Number format on the chart axis

Select Number on the format axis drop down
When you see FOrmat code (which is under the Number category), write h in Format Code, click add
AND then you'll get a single 1 hour interval.

Thanks very much for the help and advice. I’ll give this ago tomorrow.

When you see Format code (which is under the Number category), write h in Format Code, click add AND then you'll get a single 1 hour interval.

This will just round it though so will probably not work

It will if the interval is always one whole hour and the range is between 0 - 7.

The values plotted are between 1 -6.

The 0.041667 thing solved it instantly.

Kaboom

Now the question is:
When you plot these points on your chart, what chart are you going to use and why?

Afternoon all,

I’m working on a little side project. The crux of it involves have a live cell linked to a changing percentage on a website.

For example the mortgage interest on Barclays.

Data and then from web seems to be the going route, but after adding the link, I’m flummoxed