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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.