Charts
in [Excel]
|
Trend lines in charts under Excel Something I have discovered for long but which continues with Excel 2007 (under XP): when you draw a trend line in a scatter or line chart I generally get either not the best fit (or equation) and/or almost sytematically the wrong equation associated to this trend line. Has anybody seen that already and moreover ... 23 Mar 2010 16:00
How Do I Nail Down Chart Width for Printing I must make line charts, bar charts, and pie charts a uniform width (either 6.75 inches or 3.45 inches) from spreadsheet files provided by different authors (but all using Excel 2007). I use page set up narrow margins, I make the base font for the entire sheet Arial 8, I draw a line 6.75 inches wide and generat... 24 Mar 2010 10:02
EXCEL 2007 Charts Presentation If people are interested I have just uploaded a Charts Presentation to:- http://www.pierrefondes.com/ - item number 74 towards the top of my home page. It is a PowerPoint 2007 file. It just gives people a visual display, in one place, of the main charts that are available in EXCEL 2007. I hope that... 22 Mar 2010 14:16
Can't update my chart 6 months ago, in Excel 2007, I started a spreadsheet showing items bought and their usage by staff (ie. tea, coffee, soap, etc) from Sept 09 through to Feb 10. It's a really simple little chart. Just now, I renamed my Feb document as "Mar 10", added the new figures, and went to update the chart. But the char... 22 Mar 2010 00:23
changing the name in the legend I am using Excel 2007 with XP Home. I am a newbie. I am looking at the legend on a bar chart. Without changing my spreadsheet, how do you change the legend name say from "BOB" to "BOBBY" on the chart without changing the spreadsheet. Thanks ... 21 Mar 2010 20:52
Pareto charts and Run Charts Hi, I need help in making Pareto Chats and Run Charts. Regards, Aliya ... 20 Mar 2010 23:17
:(((((( help?? Hi Mike and Ed, Sorry for my slowness here :(( thank you for your help and patience! I'm still having problems :((( I feel really stupid here. Basically I have 2 macros, 806X and 807X. Macro806X just creates a simple bar chart for me. Macro806X works fine all the time. Macro807X is the 2nd macro after I run 8... 19 Mar 2010 10:48
Pie charts - 0 values Hi, I have selected data labels for my pie charts containing value and percentage. However, there are 0 values in the chart and I do not want to show them. I have tried 0%;;;; but it only hide those values in percentage while the value data labels are still visible. And when i use 0;;;; it hides the value da... 19 Mar 2010 14:23
Incorporating Text Box in Excel Chart I have a chart that has a text box at the top. Every time I change or move the chart the text box ends up out of place. Is there any way to "incorporate" text box with the chart so that it keeps its relative position as the chart changes or moves? Thanks in advance Al ... 22 Mar 2010 08:17
ReAim chart data range instead of the tedious retyping the cell references to change the data range for a chart, is there a way to do it with sliders? If so, how? thanks, Dan ... 20 Mar 2010 22:11 |