Charts
in [Excel]
|
how to calculate the area under a curve I have data in excel in cells A10 through A100. I want to obtain the area under this curve. ... 15 Mar 2010 22:55
creating a formula that looks at the value of another cell and uses that value as the row value for for a referenced cell Seems simple enough, but I have no idea how to do this. Here's an example: =IF(ROW(A3)<AO$1,'Page2'!$A?,""), where the question marks denotes the row number, the value of which, I want to get from another cell altogether. For example,say cell B1 had the value of 1000 and I wanted to use that value as my row nu... 15 Mar 2010 20:44
Copying Named Ranges in Chart Series I have a workbook with a tab that has charts and data. Because the number of data points can vary month to month, I have set up the chart to reference named ranges. The named ranges are columns that vary in length, defined by language like this: "yvals"=OFFSET('MainSheet'!$B$2,0,0,COUNTIF('MainSheet'!$B$2:$B $20... 18 Mar 2010 09:21
chart Hi!, I remember 2 years back i have done this type of chart from Scenarios or goal seek not excatly rem, but now i forget.. i want to do the chart in excel 2007.. Here is the story.. I had data for 3 different regions i.e east, west, central on different tab. On the 1st sheet i want to display one single chart... 15 Mar 2010 14:39
Chart moves on plot area when adding a third month I am working on an area chart that I update weekly. It's a very simple chart. The data looks like this: Month Count Jan-10 401 Feb-10 435 Mar-10 450 Currently the chart is only using Jan-Feb data. I'm trying to add March to the scale however every time I do the graph condenses and then relocate... 15 Mar 2010 10:06
Scatterpoot not using X values properly -- using relative ranking I have created a scatterplot where the X value is to be one value (risk) and the Y value is to be another (return). I've entered the X and Y value ranges properly and the y value is being plotted correctly, BUT the X value is not being plotted as the correct X value. Instead, the X value is being interpreted ... 12 Mar 2010 11:40
How do I change the color of the timeline boxes in my Ghant chart My ghant chart automatically boxes out my time line when I input my start and end dates for each activity. How can I change the color of the time line? I want to make different activitites different colors. ... 12 Mar 2010 09:26
pie chart not visible I have some data I want to show in a pie chart but when I do so the graph area comes up with its legend but I don't see the pie chart itself. I have tried formatting the chart settings but to no avail, help?! ... 11 Mar 2010 00:14
Excel 2007 - publish chart as htm web page file When I select a chart in Excel 7 and select Save As, I can choose file type Web Page (.htm file) just like in 2003, but it no longer gives the option to select just the chart. How do you save just the chart as a web page rather than the whole sheet or whole file? This was a simple processs in Excel 2003: 1... 12 Mar 2010 10:33
How do I extend the X-axis in Excel2007 I have a line graph of accounts on the Y-axis, plotted against months on the x-axis. I extended the axis for 2008 (in Excel 2000), I now want to extend it again for 2010, but I am having trouble. ... 27 Mar 2010 16:33 |