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 RepliesI 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).
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.
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 RelatedI'm trying to combine 2 cells that both have text on multiple lines separated by line breaks. I want to keep the formatting so that when both cells are combined, line one from cell 1 and line 1 from cell 2 are on the same line in the new combined cell. This is easy to do when there is only 1 line in each cell but how do you do this for cells with multiple lines? Here is an example of what I am trying to do:
A
B
C
1
First Name:
Last Name:
Address:
John
Smith
123 Harold Street
First Name: John
Last Name: Smith
Address: 123 Harold Street
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
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 RelatedI 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 Relatedhow 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?
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
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 RelatedHow 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 RelatedWhat's the best way to shade in the area under a line graph?
View 1 Replies View RelatedI 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 RelatedI 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
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 RelatedX-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.
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).
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 Relatedcreating 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%
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 RelatedI 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 RelatedI 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 RelatedI 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
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 RelatedI 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
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.
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
I'm simply trying to graph my data on a line graph in Excel. see the attached.
The issue is that the spacing on the x-axis is all equivalent. I want the space between the initial and 1st month to be very small while the space between 6 month and 12 month be larger.
So at the end of the day, the line will be kind of crunched down from the beginning and goes up at the 6 month data point.
Is Excel capable of handling such simple request?
Ok, so here's the trick:
I know how to create combo or mixed graphs with line/bars on single axis, and secondary axis. I even know how to do mixed stacked and unstacked columnar charts...
But how do you depict in single view graph
a single bar (1 datapoint) with a single line (upper control limit e.g. target).?
And I don't want to to use shapes to draw the target line.
I want the target line to be automatically plotted by Excel...