line graph

I have plotted lines for three data sets and am required to manipulate the data in a couple of ways in order to make each line start at (0,0). I have attached an image of my raw graph for reference below. Essentially I need to extend the linear portion of the line to the x-axis as shown below...

Good afternoon, I have some data already in a combo chart, a mixture of stacked columns and a line. The data for the line predominantly goes up in order, e.g. 1,2,3,4,5 However their may be some instances where the data will decrease, e.g. 1,2,3,2,1 I would like the line for the data where...

Hi, wonder if anyone could assist, I have created numerous data sets that with be selected by a drop down box and would like to present a line graph, but the as with the variable I would like the graph to automatically adjust the min and max axis so it looks cleaner and easier to read. I have...

Hi All, I am hoping someone could help me. I have some data that I have plotted the averages of as a line graph: My supervisors would like me to add whiskers/error bars based on the range from the data: B-SC IR-SC SC-IR SC-B Initial Inoculum Average: 7.95E+07 Range: 7.90E+07 -...

Hello, I thought this would be simple to do but I am stumped by it so hoping someone can help me. I have a line chart with months on the x axis and the quantities on the y axis. All I want to do is have months on the Y axis and quantities of the x axis but just can't work out how. If Itry...

Hi, I'm in need of some help in creating a spreadsheet and graph for my business. I haven't used Excel since I left school so I'm a little bit rusty, but I'm a fast learner. I work in a pub with a large beer garden. I want to create a spreadsheet and line graph that show the relationship...

Hello, I have a line graph with a date range of June 1, 2017 - December 31, 2018. There are no formulas. Each day a number is entered into a cell. From tomorrow through 12/31/2018 the cells are obviously empty. However, the line graph drops to zero and goes all the way to 12/31/2018. How can I...

Hello, I am using excel 2010. What I want to do is show a dotted or broken line to automatically be displayed in my line chart if the formula in the cell is NA. So I might have something like 100%, 90%, 95%, NA, 100%. It would be great if there was a regular line and then from 95% to NA to...

Is there a better and more efficent way to graph multiple rows of data. My sheet is set so that B2-B82 are classes C2-C82 week one scores D2-D82 week two scores E2-E82 week three scores F2-F82 week four scores Is there a way to create a simple line graph for each class, so that each class has...

Hi All, Nearing the end of my journey to create a Graph that updates itself based on if data exists. Background: I have 2 rows of finance over time. However only some of those cells have data. I have successfully used index and address functions to work out the address of where data starts and...

Hi there. What I am trying to do is insert intercepts into my line graph, so that my line graph is more easily readable. The problem I am facing is that my line graph is always changing based on the data that is input. Basically, without going into too much detail, I am creating a calculator...

Hi, I need to change color on a line graph, but not color for the complete line, just for one change. For example. I have 5 entries. 1, 2, 3, 4 and 5. I want that from 1 to 3 is blue color, from 3 to 4 red color and from 4 to 5 again blue color of the line. Please help :biggrin:

Suppose I have a set of data of price trend that is plotted on a line graph, labeled by date. I want to be able to input a specific date in that range, and the graph should highlight the data point on that date? Specially, I want to be able to draw a line down (This is bonus, as long as I can...

Needing to create a line graph showing oil production data for each month across several years. The way the data was logged included Jan-Dec as column headings and years 1986-2015 as row headings. How can I graph this data starting with January of 1986 and ending with December of 2015 across the...

Hello! I have a set of data similar to the following plotted as two line graphs, one for Bills, one for Coups. As any point between the two lines, I would like to find the difference. The problem is, the data points do not line up, so I can't simply take Coups minus Bills. Is there a way to...

I am currently working on my dissertation and have hit a wall. I have collected data every half an hour for 4 hours and plotted this on a line graph, however i also have data for 20 hours and 24 hours from the starting point which i cannot plot as i can't seem to create a "time gap" ? any help...

Hello, I am trying to create a line graph using excel, but the data sheet is not conducive to graphing. Specifically, I need cells C2 and R2 to be one line, and Cells D2:Q2 to be another line. I am sure this is possible I just don't know what commands to use. Thanks,

Hi, I am trying to produce a line graph which tracks performance. I have a target figure to measure performance against but I want to track by day quantities produced where the figures above the target figure is green and below the target shows as red. Can anyone help?

I would like to know if there is a way to highlight my line graph when the line passes the control limit. Also If there is anyway to highlight the line when I hover over it and show a lot more detail, that would be very cool. I have been looking around for a video or blog that would show me...

Good afternoon, I have a line graph that has varying levels of slopes. I was wondering if there was a way to conditionally format the line to show more green the more the slope is flat, show more red when the slope is very steep, and yellow/orange when it's about halfway in between. Is this...