Line Graph Based On Date Possible?
Oct 26, 2012
I have a question about creating a line graph, here's the scenario:
Once per week I update our inventory quantity in cells B1, B2, B3. I'd like to show these quantities on a graph which compares the quantity with the date. When the quantity gets updated it would automatically add week 2, when the quantity gets updated again it would again expand the graph and add week 3. Is this even possible?
Week 1
A B
Widget 2
Hammer 1
Saw 6
Week 2
A B
Widget 4
Hammer 1
Saw 6
View 2 Replies
ADVERTISEMENT
Dec 30, 2008
I want to use a line graph to display an amount over time - that's the easy part. On the other hand, I would like to have to group the lines based on a value.
A short example:
Imagine you own 3 different stores and you're selling oranges. So your table looks like this:
http://img179.imageshack.us/my.php?image=orangeshm4.jpg
Now I'd like to have one graph (3 different graphs won't work as the rows increase -I need to select the whole column as data source):
Date on the x axis,
Oranges sold on the y axis,
and one line per store (e.g. a green one for store A, a red one for B and a blue one of C, doesn't matter).
View 2 Replies
View Related
Apr 10, 2014
If I have data that shows one year back information, how do I get my chart to have the last date showing up on the axis (the date label) to always be the most current date?
View 4 Replies
View Related
Sep 30, 2009
column A = Date : 01/02, 07/02, 14/02, 21/02, 28/02 (x-axis : shows when the table is updated)
column B = project: x, x, x, x, ,x (name of the project and trend line)
column C = Delivery Date : 01/05/2009, 08/05/2009, 20/05/2009, 30/05/2009, 28/02/2009 (plotted on the graph)
column D = Status : Green, Amber, Red, Green, Blue (status of the project. the points should be the same colour as is described in the table)
column E = Comments: original, delay, supply, out of money, on track, delivered-wow! (these comments will pop up if the user holds the cursor over a point)
NB Y-axis scale : 01/01/2009 to 31/12/2009 with increments of 14 days. this will be the same scale used for all projects.
Date Project Delivery Date Status Comments
01/02 x 01/05/2009 Green original date
07/02 x 08/05/2009 Amber delay supply
14/02 x 20/05/2009 Red out of money
21/02 x 30/05/2009 Green on track
28/02 x 28/02/2009 Blue delivered-wow
So id like the macro to draw the line for project x based on the 'delivery date'. The points should be coloured according to the 'status' column and when you hover the mouse over the point the data lable will show up taking info from the 'comments' column.
Would it be possible to create a macro that will be able to generate this graph automatically. I have a few projects id like to do the same thing for.
View 14 Replies
View Related
Nov 6, 2009
With the attached spreadsheet i cannot workout how with the line graph not to continue the line if there is nothing in row 10 of the table.
for eaxmple if there is no value in cell M10, i would like the actual addtion line to stop at the last value on the graph that was in L10.
View 4 Replies
View Related
May 21, 2010
I have a chart sheet with a line graph that contains two series: I want to change their thickness, but I am not able to format it with VBA.
View 6 Replies
View Related
Nov 25, 2013
I have a row which contains a date header.
Under this there are multiple lines of activities each with a different end date and empty cells under the calendar headers so that people can enter how long they have worked against that project.
What I want to do is to compile a VBA coded which will cycle each line and at the intersection of where the end date and header match to colour that cell in a defined colour.
An example below:
Date
Colour
01 Jan
02 Jan
--->
[Code]......
View 8 Replies
View Related
Apr 14, 2014
Is there any possible to add a series to a graph table without having the line in the Graph. i just want to show the difference for information and not in the graph?
i have tried some different things (like having the difference in white so it is not visible, formatting the Axis etc)
See attached picture. Excel 2.JPG
View 4 Replies
View Related
Jan 20, 2014
I am trying to recreate the screen grab that I have copied and pasted in (purple bar chart). I am to create the bar chart, but I am unsure how to create the dotted line which is the national average.
View 3 Replies
View Related
Oct 26, 2009
I have created some charts for my work and one of them is a line chart that spreads across one year with values for each month. Well they want the graph to always show one month ahead of where we are out. So there is actuals in for Sep. but then the line graph drops all the way to 0 for Oct. I don't want to have the graph bottom out when there is a zero. Does anyone know how to fix this?
View 9 Replies
View Related
Sep 20, 2006
how to create a stacked bar & line graph together.
I know by default, I can choose to have a stacked bar, OR a line graph, OR a basic bar & line graph.
But I need to take a step further and have a stacked bar WITH a line graph.
options in which I could combine the above graphs?
View 4 Replies
View Related
Feb 15, 2007
how to have different format on a line grapgh. I have a series of data points for sales figures. The first 10 are actual data and the next 5 are projections. I want to have a line graph with solid color format for the actuals and a dashed format for the projections.
View 3 Replies
View Related
Sep 15, 2013
I need to create a line graph that has 2 lines for each person, one with the amount, one with the points. The X-Axis is by Weeks going up. How can I do this without making a separate series for each? I've attached an example.
example.xlsx
View 1 Replies
View Related
Mar 24, 2009
We are trying to create a stacked bar graph with an average line. Each time we try to add in the average data to the graph it adds it to the stacked bar. The stacked bar should represent the inpatient & outpatient cases at a hospital for the current year (months showing across the as columns). The line should represent the previous 2-yr average total. Anyone have an idea how to add a line to the stacked bar graph? It has us stumped.
View 3 Replies
View Related
Dec 8, 2009
How do i achieve the graph that is on the pdf with the data in the workbook i've attached. i cant work it out?
View 2 Replies
View Related
Dec 1, 2011
What's the best way to shade in the area under a line graph?
View 1 Replies
View Related
Feb 28, 2012
I have two line graphs I plot on a 12-month graph. In addition to these lines, I have a range, high, mid, low, for target percentages. Currently, I have plotted the high, mid, low lines and made them dashed. What I would like to do instead of just having these ranges shown as lines (w/ the graph background showing), is use the area graph function to color shade just the area between the high, mid, and low. Is this possible?
View 2 Replies
View Related
Sep 22, 2013
I have a bar graph (horizontal) for the values say Jan 1.25 Feb 2.63 Mar -1.5. This works fine; now I would like to insert static comparison lines for the values 2 and -2, i.e. a straight valued at 2 that goes Jan to Mar and another straight line at -2 from Jan to Mar..
View 2 Replies
View Related
Dec 29, 2008
X-Axis = Week1:Week13
Y-Axis =Revenue for each week.
I have a line graph. If "Week9:Week13" have no value, my graphs line drops to 0. How do I make my line graph show no value when no value is inputed for "Week9:Week13"? I think I need to incorporate the =NA() in the original formula but I'm not sure how to do this.
View 9 Replies
View Related
Apr 24, 2007
I have a line graph that contains information for the following products,
Boats , Cars & Bikes.
The chart works well but i would like to show the numbered scale of each product & i can't work out if this is possible in excel.
Currently i can only get two data showing for the axis.
I would like to show all three & just use a color to indicate which data corresponds to which product.
In my attached example: I have data for both Cars (blue) & Bikes (green) but i would like to also show data for the graph scaling for Boats (pink).
View 4 Replies
View Related
May 28, 2007
I would like to make a graph in Excel, where I present both a stacked column and a line with two different axes. Including a clustered column and a line in the same graph with two different axes is easy, as this combination can be found in the custom types selection in the chart wizard. However, there is no such alternative as a stacked column and a line with two different axes. Is combining the two manually possible?
View 2 Replies
View Related
Jul 1, 2008
creating a graph / chart using Ms Excel? I've been trying to do it myself but to no luck as I'm just a novice Ms Excel user. I'm trying to create a bar graph and combine with line graph based on these data. kindly refers to my attachment image for an example of desire graph. For line graph, it should display individually based on the given data. These are my daily data and I want to have an analysis graph so that I could monitor my computer's usage and its efficiency.
Computers Data Usage
--------------------------
Computer01 10 50.00%
Computer02 691 68.89%
Computer03 107 81.03%
Computer04 190 81.25%
Computer05 2099 82.89%
Computer06 1247 50.88%
Computer07 2786 10.00%
Computer08 69 22.00%
Computer09 300 18.00%
Computer10 1829 87.07%
Computer11 746 27.43%
Computer12 437 91.33%
Computer13 301 62.50%
Computer14 24 40.00%
Computer15 93 83.33%
Computer16 192 92.45%
View 5 Replies
View Related
Jan 17, 2014
Is there a way to get an equation for a trend line and have excel automatically export the equation to a cell where it can be used. The only way i currently know how to do this is to manually type the equation.
View 8 Replies
View Related
Oct 21, 2009
I am trying to create a line graph to show the trends (up or down) of I-Fund vs Gold. The trouble I am having is how to set the axis. The date one is an easy one, but the gold range is more or less 800-1000, and the I-Fund is 13-18. How can I have these both on the same graph to compare? I am attaching an Excel sheet as a reference. Obviously I need to delete the empty IFund cells.
View 2 Replies
View Related
Jan 2, 2013
I have an XY scatter with 40 or so different lines displayed.I want to change the thickness of all of the lines. I dont want to have to try and select them individually and change them. Is there any way to do this? Perhaps changing the default thickness of lines for this type of graph?
View 1 Replies
View Related
Jul 22, 2014
I need a hand with a worksheet that we use.
We do a penetration test on soil, write down the values from the machine, then enter into excel and it plots a line graph.
Depending on the values, sometimes a correction is required. This is manually done at the moment.
I would like to have excel do it for us.
I have attached an example of a manual correction I have done as well as the excel calculation worksheet.
There are 2 results given (one at 2.5mm penetration & one at 5.0mm penetration), we calculate both, then use the highest result for the report.
the x value is a constant and the y is a variable.
Attached Files :
Copy of Master WA CBR Worksheet Soaked.xls
DOC230714-002.pdf
View 14 Replies
View Related
Jan 13, 2014
I am reporting on the amount of certificates issued over a period of time. Basically the government stopped released data on the amount of one type of certificate being issued during this period and started releasing data on another type. I am having trouble displaying this other data which starts around half way into the time period. So all the data starts in June 2010... but this other data starts in June 2012.
View 3 Replies
View Related
May 2, 2014
I have a macro code that will create line graph referring the data given in defined column A1-C4,
Code with Static column range:-
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=Range("'Sheet2'!$A$1:$C$4")
ActiveChart.ChartType = xlLineStacked
I tried to modify the above code, so it will refer undefined/dynamic data column, but getting an error during execution "Run Time Error - 424:" "Object required"
Code with Dynamic column range:-
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=ActiveSheet.Range("a1", _
ActiveSheet.Range("a1").End(xlDown).End(xlToRight)).Select
ActiveChart.ChartType = xlLineStacked
View 1 Replies
View Related
Sep 1, 2009
I've got a formula that gives me an "#N/A" in a cell when certain conditions are met, otherwise it gives me the results of a calculation.
On the line graph that goes with uit, the "#N/A" is being treated as a zero.
View 9 Replies
View Related
Apr 11, 2007
I got a pivot table with following details Row Values: Dept_Code, Super_group, Product_Group Column Values: Ending_Date
Data: Sales, Availability%, Waste%, Number of Stores
i need to have a bar chart with trend line individually on each data items e.g.Sales, Availability% etc. when i tried to use trend line it prompts me to enter series i.e Ending_Date and it draws trend line for only that period comparing all data values. is there any way to have individual graph for Sales, Availability%, Waste%, Number of Stores with trend line covering
View 3 Replies
View Related