line chart

Hi, I am trying to plot multiple tables on the same line chart in Excel 2007. I have a list of X and Y values for Table 1, Table 2, Table 3 etc. However the size of the tables are not the same for each table. For example, Table 1 might have 200 X and Y values, Table 2 might have 175 X and Y...

Hello I have a table where to collect working hours per day, during one month (many entries for one day). Few columns after, I am using a another table to summarize the these data per day. I would like to show them on the chart (Line template) but I would like the chart to stop displaying...

I have a question about adding High-Low lines to an Excel Chart. From the office help it says that these are available in 2D line charts. http://office.microsoft.com/en-us/excel-help/add-or-remove-series-lines-drop-lines-high-low-lines-or-up-down-bars-in-a-chart-HP010007460.aspx But with the...

Hi I have a line chart with marker on excel 2007, on updating the source data the chart doesn't refresh automatically. While searching for this on line found few other forums with the same question being asked with no solution. Is it an excel bug? is there any solution available?

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 am trying to create a chart that has the primary axis as a stacked chart that shows 2 figures (numbers of sales & number of referrals). I am then adding a line that shows percentage across the chart in a secondary axis. The issue is that I need this line to show the percentage of sales that...

Hi, I am looking to create a graph with bars coming off a line graph and I was wondering about how to go about it. I want the bars to start at the point on the line graph and move up or down to the value given. For example Say my values on the line graph are 25, 15, 17, 28 and 30...

I have some data that I'd like to put into a Line Pivot Chart. The data is as follows: 1/1/10 Location 1 98% 1/1/10 Location 2 95% 2/1/10 Location 1 97% 2/1/10 Location 2 93% 3/1/10 Location 1 97% 3/1/10 Location 2 98% etc. I'd like to have the months as the x axis of...

Hi, how do you keep a set scale on an excell graph (line graph) e.g. i cm on paper = i meter on grapph results

Hello, I am trying to chart some data that contains events that last for a random duration. Lets say I have some data like this (for 20 seconds): seconds, value 0 OFF 1 OFF 2 OFF 3 ON 4 ON 5 ON 6 OFF 7 OFF 8 ON 9 ON 10 ON 11 ON 12 ON 13 OFF 14 OFF 15 OFF 16 ON 17 ON 18 ON 19 ON 20 ON It is kind...

Hi, I've looked everywhere and I cannot find a way of getting rid of the line colour in a 2007 chart, not to mention getting the right colour green of the marker, the black outline or the shadow. The macro recorder does not show the steps at all! this is what I am trying to get to: And here...

Hey all, I'm a newbie here, desparately looking for some help. My boss at work wants me to use the chart function on some excel files to make line charts in Excel 2000. My problems begin with the format of the information, and don't end there. The information is spread out among this little...

I have line graph that will read from a group of numbers that will be changing in value and in length. For example, I have an input cell for users to input a value. Based on that value it generates a list of numbers. So say they enter 25, there will be a list of 25 values. I want my line...

I am working with Excel 2007. Is there a way to get a line chart to start at zero when my data doesn't start at zero? My boss wants the data line to start at zero even though the data in the spreadsheet starts at 20.