microsoft.public.excel.charting | Forum profile

  Hi, What version of Excel and Access are you using? Thanks, Shane "joe" wrote: > Jon; > > I have tried that, and it does move the legend to the postion expected. > However, it always placed teh legend on top of the plot area, regardless of > the state of the "Show the legend without overlapping the chart" check box in > the format dialog. >...

  Hi, If you arrange your data in 3 columns keeping the values in there current row positions. 9.65 <Empty> <Empty> 5.95 <Empty> <Empty> 15.9 <Empty> <Empty> 8.25 <Empty> <Empty> <Empty> 22.5 <Empty> <Empty> 0 <Empty> <Empty> <Empty> 2.65...

  Thanks Andy, I'll follow your link and look into that.  

  Without seeing the Access macro, I don't know why the legend isn't where you want it. Unfortunately MS has made some formatting options of charts much more difficult. Right click on the legend, choose Format Legend, then on the first pane of the dialog, choose the legend position that you want. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -...

  You need to make an XY chart XY chart can also have lines on them Line charts are used when the x-values are categories (which could be numbers like zip codes but are not truly numeric in that no one ever does moth with them), XY are used when the x-values are actual numeric values best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "ColinC"...

  Smartin, Thank you so much for your insights! As I am still learning about polynomial trending and its value, they are helpful. So, let me see if I understand what you are saying. Let's say, for instance, we are talking about fluctuations in gas prices at the pump over the last x number of years, and we see how they've gone up and down and up and down and now are waaaaayyyy down (hallelujah! I paid $2.19 yesterday, a...

  Cath - The reduced gradient for a nonlinear optimization problem is similar to reduced cost for a linear problem. At the optimal solution of a linear problem, for a variable not in the solution, i.e., for a changing cell equal to zero, the reduced cost measures how much the target cell would change if the currently-zero changing cell is forced to be one instead of zero. For a nonlinear problem, at the stopping point of the...

  Code Numpty wrote: > I have data in 3 columns. > > A B C > 114.0 114.6 114.2 > 227.0 227.4 227.0 > 341.8 342.0 342.6 > 457.8 458.4 458.4 > 574.6 574.8 575.0 > 690.8 692.0 691.0 > 807.8 808.6 806.8 > 924.8 925.8 924.6 > 0.6 0.2 0.2 > > I need to take the maximum in row 9 and divide it by the maximum from the > column directly...

  So when you said y=39000+3x you meant y=39000+2x and when you said y=2800+2x you meant y=28000+3x ? Now all is clearer! -- David Biddulph "ColinC" <ColinC@discussions.microsoft.com> wrote in message news:390246EF-7AA2-42CC-975B-5DE27DA1F2F6@microsoft.com... > Hi David. It's for a simple little project I've been given in uni, > plotting > the economics of buying a...

  Thanks to everyone who answered my query.. sometimes the most obvious just isn't obvious until it's pointed out! Thanks again...:-) "Jack Yin" wrote: > Of course you can. Just insert pay breaks. > > "Edwina" <Edwina@discussions.microsoft.com> 写入消息 > news:AAEC0DC4-855C-4F3A-A5FB-47093113C951@microsoft.com... > > My question...