Chart Which Has Horizontal Gradients In Increments Of 500
Jan 30, 2009
I have a chart which has horizontal gradients in increments of 500. For example, $500, $1000, $1500, etc. Is it possible to make one of the horizontal gradient lines which run across the chart, darker than the other horizontal gradient lines? For example, if a "goal" is to reach $2000, can I make that horizontal line in the chart darker than the lines for $500, $1000, $1500, etc.? I am not talking about the bars that run vertically for each data, but the lines that run horizontally across the chart.
I dont know if this can even be done in a chart or not.
View 9 Replies
ADVERTISEMENT
Jul 3, 2012
I was able to generate a vertical bar chart combined with a line chart (dot) to use a metric guage.
However, i needed this to be horizontal and can't figure it out.
View 1 Replies
View Related
Oct 31, 2012
I am trying to create a chart with dates from the past 6 weeks (one week at a time). The horizontal axis shows the dates from my data page correctly until I make one of the other data fields a secondary axis and then my dates change from the actual dates on the data page to 1-Jan-00, 2-Jan-00, through 6-Jan-00.
When I do the select data and look at the dats in the Horizontal Axis labels box, it shows the real dates. Why won't they show up on the chart as actual dates?
View 2 Replies
View Related
Apr 10, 2014
I have a data series plotted as columns. Then I want a horizontal line at $5,000 to appear all the way across the chart. It appears from the 1st to the last data point, but there is blank space before the first point and after the last point. I would like the red line to extend into this blank space before and after, so that it is going across the entire chart.
I tried playing around with different axis settings and no luck.
View 2 Replies
View Related
Aug 25, 2006
I have a line Chart and want to create a static horizontal/indicator line.
I cannot create a new series to plot this horizontal line as I'm using an external data source (OLAP cube) as source data for the chart.
View 8 Replies
View Related
Apr 12, 2014
I'm having trouble getting the dates i want on the horizontal axis on a chart in Excel 2013. I want 12 dates along the axis starting at 01/01/2013 then each month until 1/12/13 however as you can see the dates are 01/01/1900.
View 10 Replies
View Related
Feb 25, 2011
I am using the the stock chart and I would like there to be a horizontal line across the chart with a y-axis of the opening price. In the end I want this to be in VBA but how to do this manually I should be able to put it in loop of data that will produce many charts with a horizontal line starting at the day opening.
I have tried to add a new series to the chart but I'm using the Candle stick stock chart and the new series comes out as a vertical not horizontal line. I read about using a secondary horizontal axis but all the tutorials I find are in Excel 2003 and they donlt line up well with Excel 2007.
I found this link on charts with horizontal lines but again they are in 2003 and I'm using a candle stick stock chart not a scatter chart. [URL]
View 6 Replies
View Related
Oct 11, 2011
I want to a horizontal line in a chart. There are only two figures with me. One I want to display as a column chart. The other as a horizontal line chart. (I can use both excel 2003 or 2010, whichever is suitable)
View 2 Replies
View Related
Aug 21, 2012
I was wondering how do you create a horizontal bar chart where the allocations within the bars change as the percentages change.
For example, if I have school stats where the there are 30 students in each class from grades 1 to 5 broken down between girls and boys
how can I get the bars for EACH grade to reflect the allocation between boys/girls?
View 3 Replies
View Related
Feb 13, 2009
I am trying to work out how to convert the slope/gradient from degrees to %, and ratio.
View 7 Replies
View Related
Aug 24, 2012
I am working with the Ganntt chart and horizontal bar charts but can't seem to figure out a way to force the X-Axis to behave properly.
In Excel 2007, I am trying to get the X-Axis to show major units of Months. However, in my chart options I can only change the Y-Axis to be Date/Monthly.
Changing my data layout (from the below) to be a vertical format produces the same problem, just in the other direction.
My data looks as follows:
System
Blocker
Production
Migrataion
Retired
Sys1
1/1/2012
780
Sys2
1/1/2012
400
60
90
Sys3
2/1/2013
30
5
1
The Blocker column is formatted as "No Fill" in order to cover a portion of the time-scale.
My X-Axis displays as random dates throughout the period and all of my data displays properly in terms of the scale on the grid.
What is NOT working is that the dates shown on the X-Axis really need to be based on a Monthly scale instead of the randomly selected dates Excel is using.
20120823.xlsx
I can't seem to find the right combination of options to make that happen or force a scale on the X-Axis.
View 1 Replies
View Related
Jan 16, 2013
We make many graphs using XYscatter charts with lots of data points using Excel 2003 with the horizontal scale properly scaled as frequency. I have been asked to label that axis in some way as period (=1/frequency) without changing the scaling for the data plot. Is there a suitable way to do this? It would be OK to just change the axis numbers to 1/frequency computed from them automatically. Is Excel 2010 any easier for this?
View 9 Replies
View Related
Mar 1, 2014
I have a spreadsheet with golfers handicaps, golfers names down the left in column A in rows 3-35. Row 2 has the event numbers titles 1 to 18 (18 events in a year). i need a graph that has the person as the vert axis and the horizontal axis needs to be the event numbers, so i can read down for the person and across to see how there handicaps change from each different event. i have attached the data below.
View 1 Replies
View Related
Jan 26, 2008
What is the best way to have both horizontal and vertical axis as value axis?
View 2 Replies
View Related
Nov 30, 2007
I have a large database, and I wrote a macro to update it. However, the sheer volume of data makes it difficult to update at once (without crashing my machine), and I would like to know if there is a simple way to run the macro in increments ---say, 2,000 rows of data at once. Just wondering if these is an efficient way to code this, rather than hardcode partitions into visual basic.
View 2 Replies
View Related
Mar 19, 2014
I attached document, in that document I made formula in Pressure cell which is INDEX MATCH MATCH to get the result.
But what I wanted is, when I type 10.4 in Temperature cell, the Pressure cell will show the result which is 1261.24 directly without I have to fill in two temperature cell to make it 10.4.
View 11 Replies
View Related
Jul 8, 2013
Below are the equations in 3 cells. They are averaging intervals of 7 cells without overlap.
=AVERAGE(A2:A8)
=AVERAGE(A9:A15)
=AVERAGE(A16:A22)
If I autofill, Excel does not seem to be able to recognize that pattern. Instead, Excel adds 1 to each row so that the fourth cell is as follows:
=AVERAGE(A17:A23)
But rather, the fourth cell should be the following:
=AVERAGE(A23:A29)
Is there a way to autofill with the 7 cell intervals?
View 3 Replies
View Related
Feb 13, 2009
Suppose I have an optionbutton named for each day in February, say Feb1, Feb2, Feb3, etc. Would the following code do what I want it to do?
View 4 Replies
View Related
Mar 22, 2012
I am trying to make a bill of materials using excel. The material is 10' sticks of pipe. What I want to accomplish is have a column (column A) with the lengths used in inches and have it show me the total amount of pipe used keeping in mind that once you hit 120" you have to start a new stick of pipe.
For example: If I used 40 inches I have 80 inches left over... But if column A read (40", 90", 60") I need it to know that the 40" will be cut from one stick, the 90" will need to be cut from a new stick, and the 60" can be cut from the left over of the 40" cut.
View 1 Replies
View Related
Oct 15, 2006
For i = 10 To 260 Step 10
iStrg = i
cntrl = "A" & iStrg
Range(cntrl).Value = i
Next i
I have been trying to use this code which displays 10 in A10, 20 in A20, 30 in A30....etc. What i am trying to do is display 0 to 260 with a step of 10 in the cells A2 to A28, could anyone be of assistance?
View 7 Replies
View Related
Feb 13, 2007
I have a column named "Time" and when I enter the data in the first row (for instance 6:00), I would like time to be inserted in the rows below in 5 minute increments.
But as an addition, I would like an input box that requires the end time. For instance, if I enter 6:00 in the first row, I should have a input box requesting me to enter end time. If I enter let's say 8:00, then time (in 5 minute increments) should be entered until time is 8:00.
Is it possible to do this in Excel? If it is, how would I go about it?
View 10 Replies
View Related
Feb 11, 2013
How do I write a formula to round the decimal places in a number in set increments. For example;
a) 14.28 to the nearest 0.25 would result 14.25
b) 1.99 to the nearest 0.1 would result 2.0
c)2.97 to the nearest 0.25 would result 3.00
View 2 Replies
View Related
May 7, 2008
I need an equation that will take time and turn it into quaters increments. Meaning, If we work on a computer for 1 hour and 15 minutes (1:15) then i need it to say 1.25.
1:00-1:15 =1.25
1:15-1:30 = 1.50
1:30-1:45 = 1.75
1:45 - 2 = 2.00
and so on... up to 3 hours.
If E2 = 1:00-1:15 then F2 =1.25
If E2 1:15 then F2 = 1.50
View 9 Replies
View Related
May 5, 2006
I have a set of number in worksheet IN:
A B C D E Columns
41.0141.0241.0341.0441.0
42.142.242.342.442.
43.0143.0243.0343.0443.0
44.144.244.344.444.
45.0145.0245.0345.0445.0
46.146.246.346.446.
Datarows increment by 1. I need to map these to another workbook worksheet named OUT
to rows that increment by various amounts 1,2,3 ....10) i.e..............................
View 7 Replies
View Related
Feb 7, 2007
My employer gave me a life insurance "Rate per Age" chart to convert to an Excel spreadsheet.
The chart shows rate increases in 5 year increments starting at age <29 and increasing in steps as follows: 30-34, 35-39 through 95-99.
If I input an employee's birthdate I am hoping to calculate the date when he/she will hit each 5 year step increase.
View 9 Replies
View Related
May 13, 2008
I'm trying to write some VBA code that can vary an undefined number of variables from a certain value to a certain value and by a certain increment. I know I can do this using For, from to step function but I could potentially have as many as 60 variables that need to be permuted and as little as 1.
For example:
Permute variable 1 from 2 to 6 by 2
Permute variable 2 from 6 to 8 by 1
should output
2 6
2 7
2 8
4 6
4 7
4 8
6 6
6 7
6 8
how to make this code efficient instead of writing 60 for loops? that could either be used or not?
View 4 Replies
View Related
Jan 1, 2009
I don't know if title is understandable, English not being my tongue, anyway here's my problem, the current value must be increased or decreased by 0.01 if it's between 1 and 2, by 0.02 between 2 and 3 and so on. I'm really new to VBA and after a few hours I came up with the following code which works fine till the value of 6 and then gets stuck: ....
View 14 Replies
View Related
Sep 30, 2008
I'v been trying to do this for a while now. I need a function that takes this date (which is not a set format in Excel, so has to be 'general'):
10.10.2007 00:00
10.10.2007 06:00
10.10.2007 12:00
10.10.2007 18:00
11.11.2007 00:00
...
...
...etc
I need a function that increments this type of date format in a column.
View 5 Replies
View Related
May 9, 2012
i'm looking for a loop macro to perform the following task:
Sheet 2 is my look up table, and sheet 1 as a number of references such as:
='Sheet 2'!B1
='Sheet 2'!E1
='Sheet 2'!G1 etc
I need a macro that increases the row references "1" to "2", saves the sheet then increases "2" to "3" and so on until the bottom of the reference table is reached
View 1 Replies
View Related
Sep 6, 2007
I am looking for a formula that I can drag down a column that is pulling data from left to right at the top of my spreadsheet. See the attachment.
View 5 Replies
View Related
