Charts
in [Excel]
|
How does Excel smooth chart data when smooth option is selected? When I graph data in an Excel spreadsheet and select data series format, there is a check box for "smoothed line". I would like to know what type of smoothing is performed to produce the resulting curve. Thanks ... 19 Apr 2007 01:08
Creating a pareto chart hi all, would somebody advise me how to make automatic pareto chart. thank's before ... 9 Apr 2007 08:27
Export from Excel to Word I update an excel template using data from an Access database. I am unable to paste the excel chart to a word doc as it is a template. As the user wants to create a report made up of many pie charts/graphs (12 in total) with the ablility to enter free text at the start of the report any ideas on where to look... 28 Mar 2007 10:20
How do I do cluster analysis in Excel 2003? How do I do cluster analysis in Excel 2003? ... 28 Mar 2007 20:15
how to generate a polynomial regression graph with 90% CI? How do I add a trend line with the 10th, 50th and 90th percentiles to a scattergram graph? ... 19 Mar 2007 10:55
Change category width... Hi all, Is it possible, on the X axis of the column chart, to make the category width thinner? I want to be able to put the columns next to each other without a gap, but I don't want to make the columns wider than they are (ie I don't want to use gap width). Many thanks Andy ... 1 Mar 2007 15:46
VBA to specify chart location as obj in current sheet? Hi, I have recorded the following... Sub Macro4() ' ' Macro4 Macro ' Macro recorded 23/02/2007 by Dan ' ' Keyboard Shortcut: Ctrl+f ' Columns("A:B").Select Charts.Add ActiveChart.ChartType = xlXYScatterSmoothNoMarkers With ActiveChart.Axes(xlCategory) .HasMajorGridlines = ... 23 Feb 2007 10:52
Pivot table error when Opening an Xml Spreadsheet from MS excel Xp Hi, I have saved an excel file as an xml file that has a pivot table. When i open the same xml spreadsheet again in excel and click on the pivot table, it gives me the error as below. "This pivot table report is not valid" But it works when i refresh data for the pivot table. Hence, I have to refresh ... 16 Oct 2006 03:22
tornado chart Is anyone familiar with how to create a "Tornado" chart in Excel? Thanks. ... 25 Aug 2005 12:50
How do I make a nomogram in Excel? I wanna make a nomogram in excel, can sombebody help me?? ... 8 Mar 2005 20:09 |