line chart

Hello there, I request your help on solving this question. Say, I have values such as 1,2,3,4,5,6,7,8,9,10 plotted in Excel Chart. If I want to delete values 3,4, the missing values can be interpolated using the "Hidden and Empty Cells" option. This option connects only through a thick line...

Hi there, I'm currently trying to plot two different data sets on the same line graph. The x-axis is time for both, however, the time is spaced at different intervals for each. (i.e. one records a point every 15 seconds, and the other records a point every 20 sec). My attempt at combining...

Imgur I want to plot a line chart for the max spread over time, can anyone assist me in doing this as i'm getting confused when going to select data etc. I want it so that the time is x axis and the y is the amount of spread over time. Also so when the data updates, the chart changes with it...

Hello, I currently have a line chart in Excel 2010 which documents the level of total charges on specific dates. The reports that these data points are based on is not run on a regular basis, so I am using a Text Axis to capture and display only the specific dates on the X-axis, which are as...

Hi, I am extremely new with VBA and have been trying for several hours on on how to change my x-axis label which now reads "1 to 12" to a string/text /timescale "Jan to Dec". my data structure looks similar to the below Dept Jan Feb March w 20 30 20 x 40 34 54 y...

I am working on a project that I need to create a Line Chart from the data that the user enter weekly. This is what I've got so far: ' Graph ActiveSheet.ChartObjects("Comparison").Activate ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).name = "=""Actual...

Hi All I have a line chart that displays a comission scheme for a salesperson. The commission paid (Y axis) depends on the sales generated (X axis). Let's assume $100 = $0 payment $200 = $0 payment $300 = $50 payment $400 = $100 payment At $299 of sales, nothing is paid. The line should...

<TBODY> Plan</SPAN> POC</SPAN> Setup</SPAN> Reaff</SPAN> Jan</SPAN> 50.00%</SPAN> 10.00%</SPAN> 15.00%</SPAN> 10.00%</SPAN> Feb</SPAN> 40.00%</SPAN> 20.00%</SPAN> 20.00%</SPAN> 20.00%</SPAN> Mar</SPAN> 30.00%</SPAN> 30.00%</SPAN> 25.00%</SPAN> 30.00%</SPAN> Apr</SPAN>...

Hi, hope some of you gurus can help me please. I have a large download of data from a Gas meter, which I need to analyse to show a line chart with 3 lines: max, min and avg values for each time slot per weekday (M-F) and per weekend day (S-S). Time slots on X axis (horiz) & value of gas used on...

Hello, I know this can be doen and have done it previously but it seems as I cant rememebr how this morning - i am wanting to prepare a line chart that will compare two sets of data. I want the X axis to be days of the week - M, T, W, Th, F and the Y axis is going to be the item - So I want one...

Hello Everyone, I have the following data: <tbody> <tbody> 1,562,500 </tbody> <tbody> 1,150,431 </tbody> <tbody> 1,096,033 </tbody> <tbody> 1,054,040 </tbody> <tbody> 1,018,854 </tbody> <tbody> 989,181 </tbody> <tbody> 963,960 </tbody> <tbody> 942,492 </tbody>...

Hi there guys, A question for you on this fine day! I have a line chart for a number of years, but there may not be a figure for a certain year. So, if I have year 2009-2014, in 2011, there may be no figure. I don't want the chart to drop to zero (which it does if I put in a zero). I also...

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...

Hi all, I'm using Excel 2010. My charting skills are not so good so I'm turning to this forum for help! Here is how my data looks: Now I need to create a line chart with Quarters on the x-axis and Values on the y-axis. The lines inside the Chart will be those showing the room nights and...

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...

Hey Everyone, I have 1 data set with a bunch of columns, the ones needed for this question are Column H (header: Created, shows a list of dates when a specific request was created) and Column AK (header: Status, shows the status of the created request [i.e. Approved; Invalid; etc]) I need a...

Hi all, When building charts, I always like to include confidence intervals so the reader has a sense of how solid the results are. However, I don't think error bars do a great job of visually demonstrating the idea of a confidence interval. It shows the upper and lower range, but doesn't...

I Have a table like the one below. How can I plot Time on the x-axis, and throughput1, throughput2, Erl1 and Erl2 on the y-axis for each of the value in column "Name"(i.e. DRN1, ERN1, ERN1 and IRN1) <colgroup><col><col><col><col><col><col></colgroup><tbody> Time Name throughput1(kbit/s)...

Hi Guys, I am working with line charts and i am successively drawing line charts based on the number of rows. Each row contains one line chart and every time chart is drawn on new worksheet (e.g., if there are 5 rows then on single click 5 line charts will be drawn). The problem that i am facing...

Does anybody knows how to create a Line Chart with Conditional Formatting? I want to format the line as red if it is off the target and green if it is better than the target. Thanks!