Combined Bar And Line Graph/Chart

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%

ADVERTISEMENT

How Do I Not Graph A 0 Value On A Line Chart

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

Graph The Following Data In An Area Chart With Line Charts Superimposed On The Area Chart

Nov 1, 2006

I am trying to graph the following data in an area chart with line charts superimposed on the area chart. I have a lot of data (and a lot going on) so I'm trying to figure out the best way to show this in excel from a functional standpoing (i can't get this to work in excel!!) to also an asthetic standpoint (dont want it to look terrible or illegible). This is what I'm trying to chart:

1) Weather data (temperature) by region:
So one region, would be: Northwest
I would like the "area" (so a shaded region) to be the min/max of the temperature data for each month.

2) I would like to show the temperature for each year as a line graph on the chart - so you can see if a year falls in or out of the shaded region.

3) I would like to show a company's sales increases across the same months per year as separate line charts. I may choose to just show the biggest outlier year in the end... or to show 2006 (the latest data).

What I am trying to convery with the chart is that the company's sales is or is not tied to weather deviations. I have attached an excel file with the data. I haven't been able to use the area chart or get a two axis chart to work or get it to look even remotely professional.

View 3 Replies View Related

Get Line In Graph To Become Curved Between 2 Data Points In 10 Point Chart?

Feb 21, 2014

how to get a line in a graph to become a curved line between 2 data points in 10 point chart. I the pictuer attached I am trying to get the line to curve at the second data point 5(ms) and the third data point at 80(ms). The aftr 80 the line become staright again.[IMG][/IMG]

View 3 Replies View Related

Select Series (lines) In Line Graph By Adding Userform With Checkboxes On A Chart

Apr 15, 2014

I want to add a user-form on a chart, which will have check-boxes that will allow me to select series(lines) that I want see and compare in a chart. Currently my line chart has 24 series (Lines) which makes the chart very difficult to view and looks very busy. How do I add list of check-boxes that will allow me to select one or multiple lines that I want to see at a time?

View 2 Replies View Related

Line Graph: (line Graph To Display An Amount Over Time)

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

Line Graph Not To Continue The Line If There Is Nothing In Row 10 Of The Table

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

How To Change Line Thickness In Line Graph

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

X Axis Dates Not Appearing Correctly In Combined Chart

Jun 2, 2014

I got a problem with displaying my dates correctly on the X-axis of my combined column - line graph. For some reason X-axis labels appear as consecutive numbers with regards to number of data points. Please see attached.

Also, why does the indent change as seen in this screenshot?

Last but not least, how can I prevent my secondary axis label from coinciding with the labels as seen here?

May_Daily_and_Total_Revs_by_date.xlsx‎

View 4 Replies View Related

Excel 2003 :: Filter Data In Graph / Chart (without Having To Create New Chart)

Dec 29, 2011

I have a spreadsheet created in Excel 2003 (which is what we use at work, unfortunately).

My employees periodically take a test to ensure they have certain items memorized (or are making progress to that end). The spreadsheet rows show all 46 of my employees, and their test scores. The columns are the dates that the tests are administered. I can create a line graph based on the chart data, and interpolate these data with no problems.

The problem is that there are 46 employees! 46 lines on the same graph make for a very cluttered, hard to understand visual. I want to simplify the view by "filtering out" some of the data.

I have an additional column in my spreadsheet for each employee's work area (Area 1, Area 2, etc), and another column with data based on first letter of last name (the values here could be "A-G", "H-M", "N-S" and "T-Z", for example). I figure i could filter my line graph based on these two columns. For example, somehow select just Area 1, and reduce the number of lines on the graph to 16. Or better yet, Choose "Area 2" AND "A-M" and end up with 7 employees (and therefore 7 lines on the graph).

Here's what i have tried:

1) Select the work area column, and use the Filter, which created a drop-down list at the column heading. When i use this drop-down list, i can easily filter the data in the worksheet by Work Area, but this is not reflected in the line graph, which still shows all 46 lines. The problem was that i forgot that i had set the Calculation Options to "Manual". Setting this to "Automatic" (or leaving it on Manual and pressing F9) solved the problem, as the chart now updates when i use the filters. Calculation options are under the "Formula" tab in 2007, or in Tools -> Options -> [either calculation or formula, i forget what it's called] in 2003.

2) Create several separate line graphs in several separate sheets. I wouldn't want to assign someone else the task of maintaining a spreadsheet of such inefficient design.

View 1 Replies View Related

Excel 2010 :: Add Pie Chart Into Data Point Marker On Line Chart

Nov 27, 2011

I am looking for a creative way to display a pie chart within a data point marker of a line chart.

My database has 3 value columns, Type1, Type2 and the Total (Type1 + Type2)
these are recorded per day (Date, in Column A)

I have a line chart that displays the total by date, but I want to find a way to display the percentage split of a particular day by type.

I was thinking to load the chart image into the Data point marker, but i don't think that is the best way as the data is updated daily and I would have to do it each day for a few line charts.

The other way I was thinking about was to have a generic Pie chat in the Line chart (Maybe in a corner) and the pie would update depending on way date series was selected or Mouseover'd)

the way that I am approaching it at the movement (Not the best way and by far not the coolest way. Is to have a list of all the dates in a column next to the Line chart and using some VBA, what ever date is selected in the column the pie chart displays the corresponding data. But eh challenge is that when there is alot of dates, I am going to be scrolling up and down.

I am using Excel 2010, but I cant not use the slicer's as the other users do not have 2010, they have 2007.

View 1 Replies View Related

Adding Comparison Line Chart To And Existing Population Pyramid Chart

Jul 14, 2012

I have created a population pyramid and want to add another chart on the secondary axis which I can do. The part which I seem not to be able to complete is getting the line chart secondary axis to read from the primary y axis. It seems to add a new axis, even when I delete this the line chart does not read correctly.

View 1 Replies View Related

Show Missing Values In Pivot Chart (line Chart) Axis?

Apr 18, 2013

How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart.

View 1 Replies View Related

Overlay Line Chart On Top Of Stacked Column Chart?

Feb 15, 2012

I am trying to overlay a line chart on top of a stacked column chart. The stacked column chart is a chart where the x axis is dates and the y axis is amount. The line chart is a projected amount that I will reach in few years; the x axis is the date while the y axis is an amount. I can get a chart that has a line and stacked columns, but ever time, the dates get messed up. The line has an extremely wide date range while the columns only have about a month of data.

View 9 Replies View Related

Line Chart - 12 Month Chart Moving With Dates

Jan 22, 2008

Is there a way to display only the current month and the past 11 months in a Line Chart in Excel? So if I was to print Jan 2008 Excel graph, it would only display Feb 2007 - Jan 2008 data charting.

The spreadsheet of the data contains data for Jan 2005 - Jan 2008 so far, but only the current month with the past 11 months should display in the line chart depending on what is the current month.

View 13 Replies View Related

How To Add Series Without The Graph Line

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

Adding Line To Bar Graph?

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

Stacked Bar & Line Graph

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

Formatting Line Graph

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

Line Graph With 2 Lines Per Person?

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

Stacked Bar Graph With Average Line

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

Line Graph In Descending Order

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

Shade In Area Under Line Graph?

Dec 1, 2011

What's the best way to shade in the area under a line graph?

View 1 Replies View Related

Combination Line / Area Graph

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

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 View Related

Static Comparison Line On Graph

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

Line Graph Show No Value When No Value Is Inputed

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

Third Axis Data - Line Graph

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

Stacked Column & Line In Same Graph

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

Column Chart With Line Chart And Percentage?

Sep 15, 2014

In the attached file I have the data which shows me the market size in value, my market share in value & I did a calculation to get the percentage. What I need is a chart that shows me the market size in column graph, my market share in line graph and I want the percentages to be showing also.

View 3 Replies View Related

Pareto Chart, Set Line Chart Origin At Zero

Nov 28, 2008

I have a pareto chart(Bar & Cumulative Line Chart) that I would like to have the line orginate at x = 0 & y = 0 without changing the position of the other points on the line chart.

Basically this is for better visual appearance. When I add a 0 to the table, it skews the alignment of the line chart with the corresponding bar chart.

View 7 Replies View Related

Line Chart To XY Chart And Vice-Versa

Feb 5, 2010

Attached is the sample data worksheet. Chart 1 is XY type chart using Seconds (2nd column of sample sheet as x-axis from 42510 to 42530). How do I change it to Line chart using Time (1st column of sample sheet as the X-axis) retaining same data from 42510 to 42530 on both primary and secondary axis?. And how do I again change it back to XY chart?

View 3 Replies View Related

Export Graph Trend Line Equation

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

Creating A Line Graph With 2 Sets Of Values

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

Change All Line Thicknesses In Scatter Graph

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

VBA Code For A Correction To Basic Line Graph

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

Start Scatter Line Data Later In Graph?

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

Macro Code To Create Line Graph

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

Removing Zeros In A Line Graph 2007

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

Pivot Multiple Graph And Trend Line

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

Graphing With Proportional Intervals On X-axis Line Graph

Aug 14, 2014

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?

View 3 Replies View Related

ADVERTISEMENT