line graph

I am creating a template/form for a table and a line chart that represents the data in the table. This is for progress monitoring in a school system. The table includes 37 weeks (columns). I want to add another row for a Goal line. The goal will increase each week (column). It would be really...

Hello everyone, I am enrolled in an online math program and need to submit a geometric graph. It needs to have an x and y axis, but nothing fancy - it will just be a few line segments. I cannot find a way to do this in Excel (I have the 2011 version). Is there a way? If so, how can I do it...

So i am making a graph o fthe following data A1 to A12 have month Jan to Dec B1 to B6 have 1 2 4 5 6 and C7 to C12 have 7 8 9 10 12 in the respective months . I want to show a continuous line graph on the X axis.. so that when the graph is don i have a line connecting 1 2 4 5 6 and then another...

Hey guys, I have never ever programmed with vba. But i need to make 70 line plots from every individual column in a data set, so i figured i'd give it a try. I found a code that does what i want for a certain column. This is the code when i do it for my first column (B), in column A there is...

Hi guys, I'm new here and probably the most noob in the world of excel and VBA programming. Recently, we are creating a sort of calculator for Tuberculosis (TB). One part of which is the generation of graph based on the data provided by the World Health Organization. I have successfully...

Hi there, I've been struggling to combine these two different types of graphs together - I have made the stacked bar graph and a line graph and would love to just somehow overlay the bar graph with the line graph. From the research I've done I've seen recommendations to add the data relating...

I am using the following table of data to create a line graph: <colgroup><col><col></colgroup><tbody> Year FSR Redeeming Operators 2006 1,203 2007 8,839 2008 14,984 2009 20,229 2010 30,216 2011 33,761 2012 34,448 2013 34,846 </tbody> Unfortunately, when I select this data and...

How can I filter dates on a table for a specific range? Can I use =Today()-365 to capture the last 365 entries. I am trying to capture a rolling date range for a line graph. For some reason the offset equation will not work.

I am trying to figure out how to add high/low points to a line graph, similar to what sparklines have. The file I am using now doesn't allow me to add new columns of data, so I'm trying to figure something out that just updates dynamically using the data I already have in place. This page has...

I would consider myself almost an expert with excel charts as far as creating different views by manipulating the graph format to come up with something you just didn't think was possible with Excel Charts. Given that... here is my question or challenge if anyone can help me out. Let's say you...

Hey everyone! I'm working on a project for work that has data ranging from 3-400. My supervisor wanted me to create a line graph but I needed some pointers since the data has huge gaps. I set the data to go in increments of 10 and cap at 100 (since there are only two points that extend beyond...

This seems like a really stupid problem but I don't know how to fix it! I have a table that looks like this: <tbody> Year Megawatts 2010 55 2011 106 2012 174 2013 326 2014 618 2015 1121 </tbody> I want to make a line graph that just shows the growth in megawatts over time, with...

Hi I am looking for a macro that will change the colour of segments of a line graph to a different color depending on if a value meets an IF condition. So the rest of the line graph should be one color and different parts of the same line graph should be another color. There are four sets of...

Hi, Kindly put me through on how to plot and group Data in 3D Dimensional Scatter/Line Graph in MS Excel. Thanks

This is the problem: I'm trying to make a force x velocity line graph with pre and post variables in this chart. The problem is that the post variables for velocity doesn't fit in, in the x axis with the pre variables. How do I do that?? PS: Sorry for bad english :)

Hello, I'm having a problem with my line graphs defaulting to 0 on the vertical axis. I select Auto for the minimum axis in the axis options frame, but for some reason it keeps defaulting to 0, even when I have a chart with 80, 85, and 90 as values. There's no way I can manually set it...

Thank you for reading my post. I am using Excel 2010 on Windows 7. I work in the purchasing department and have been asked to develop a dashboard to monitor supplier performance. One of the metrics I would like to include is stock performance. I would like to include a line graph of...

Hi, I would like to include error bars for confidence intervals on a line graph, and this involves customising the data points. However, it seems I must apply the interval I choose (using the customise function) to the whole series, and this is no good, as the interval is different for each...

There are 3 students. I made a graph of their score in 2010 and 2011. Now I wanna circle their performance and write it's for 2010 and 2011. I have seen such marking in several places. Is there any option to make such circle in graph in MS Excel? Please check the example of my graph. I used...

I cannot for the life of me figure this out and I am past frustration. My gist of my data is comparing the mileage of a truck with the costs of maintenance on that truck. Whenever the vehicle is brought in, the mileage was recorded along with the repair costs. I have a long list of values for...