use stock plot to draw point estimation with confidence interval0956 (12/11/2011 2:48:24 PM) zmring(3) Dear All, I am trying to use stock plot to draw point estimation with confidence interval. When number of groups are more than 2, it works. But when number of groups is 2, it doesn't work. Could you check the...
Avoiding cells being included in a chart4833 (12/9/2011 9:43:27 AM) FI have a simple column chart which displays a value for each day of the month taken from cells B19 to B49. Days 1 to 31 are taken from cells A19 to A49 and displayed on the X axis. As the month progresses I ...
how to add error bars into bar chart0713 (12/6/2011 7:35:04 PM) zmring(3)Dear All, I am trying to use the following code to create a bar chart with error bar. But failed on ...... .ErrorBar Direction:=xlY, Include:=xlBoth, Type:=xlCustom, Amount:=errBar ...... Could an...
Chart Question #65741 (11/2/2011 7:39:19 PM) cmiedaner(3)I have a list of 200 stocks. The data table looks like this: Stock Price Low High AA 10.37 1.00 19.00 AAPL 396.51 350.00 450.00 ABX 49.32 36.00 65.00 AIG 23.42 15.00 34.00 Is there a way to create a chart th...
Charts #3701021 (10/24/2011 6:14:28 AM) niranjan.mv005(1)Hi All, Can you please advise if we can create one chart with multiple pivot table of the same data. Thanks Niranjan ...
Excel 2007 Line Chart - Chart line to go directly to next value3991 (10/11/2011 10:40:45 PM) brettmanning24(11)Hello, Is it possible to configure a line chart in Excel 2007 to ignore the intervals and graph straight to the next value. For example if I have the periods: Jan with the value 1000 Feb with the value 900 M...
Export to image ... way to get just cells without chart background?31121 (8/18/2011 6:21:34 AM) tAcceptSpam(91)I found code to export a range of cell, B1:B4, to an image on the desktop and it works just great. I need to finetune the macro a bit and had posted in the programming ng but there's been no answer which only ...
Charts When There Are No Data Values Sometimes ?1874 (10/4/2011 12:39:43 PM) rgsros3251(59)Hello, Using Excel 2007. Have a row of dates in one Column, and data in the next. Although the column of dates is contiguous, one after the other, only some of the dates actually have a data value next to i...
insert comment6978 (3/22/2007 6:13:46 PM) Matsd(2)Is there a way to insert comments in a graph? (Excel 2003) ...
Too many points on horiz axis0886 (9/7/2011 4:00:24 PM) FakeMail(99)I'm working with an MS Chart/Graph in an Access form. I realize this is an Excel newsgroup, but I can't get any response in the Access newsgroup. Hence terms such as "form" "rowsource," etc., may not seem fa...
Overlaying 2 Data Series with Different Time (X) Axis3938 (8/27/2011 12:25:28 PM) notvalid1(96)Win XP Pro Excel 2002 SP3 Hi, I need to chart (overlay) 2 data series over the same period of time, say January 1, 2010 to December 31, 2010. The problem is twofold: 1) The series are very much out of the ...
Line with length depending on the value of the cell1592 (8/15/2011 3:35:55 AM) getsubodh(1)Hi All, I want to get a line in a row of cell, lets say from in Row1. And, if the value in A1 is 1 the line should be in Cell B1 if 2 the the line should be in cell b1...
A line chart3899 (8/22/2011 9:22:54 PM) true.kilted.scot(59)I have two scores, Internal & External, and I want to plot these on a chart. However, I want Internal to be on the Y-Axis, going across and External to be on the X-Axis, going up. The idea being to find the i...
Trend line with negatives Excel 20070725 (8/6/2011 10:59:56 PM) the.christies(30)Hi folks. I am trying to put a trend line through some points in a scatter graph Excel 2007. Usually the trend line starts with the smallest point and goes to the largest. My data has all negative x values. ...
3D graph (yield curve)21717 (5/2/2008 7:20:00 AM) ArneHegefors(7)Hi! I want to make a 3D graph showing the developement of the US treasury curve over time. My data looks like this: In column A i have a list of dates. In column B I have the yield for the 1 year tenor corres...
File storing and URLs for files51004 (6/17/2011 11:46:04 PM) the.christies(30)Hi folks I know that we cannot attach an example Excel file when we send a message to this group. However, not too long ago, on one of the Excel groups, someone explained how you can upload the file to a fil...
Pivot Table: deleted source data1677 (7/19/2011 4:20:26 PM) tyrone_bak(11)Is it a common practice to delete the source data for a Pivot Table? Why do the Pivot Table maintain the data after the source is deleted? I was trying to reverse engineer a Pivot Table that was created in 200...
Range of Object _Global Failed0718 (7/13/2011 6:33:04 PM) jeffrmarks(10) I'm trying to create multiple charts via a macro in Excel 2007. I'm getting a 1004 - Range of Object _Global Failed on the indicated statement. I believe I've done something wrong with the last Range in that...