ProcessTrends.Com D. Kelly O'Day
http://www.ProcessTrends.com/
Excel Charting Hyperlinks
Help to find charting Information that uou are looking for
To find links to Excel Charts articles, go to Query sheet, press Query button. You will be prompted to enter topic. Query will return lsit of links from Article list that meets your request. Links are live. If you are connected to inernet, link will bring you to the article.
Query
Article
Author
Link
Article Average lines Broken Lines for formula linked data Complex Line Intersection Conditional line chart Labelling the last point on a chart Scrolling chart Step Line charts Min and max Points Dynamic chart: add new data and the chart expands. How can I document my worksheet showing row and column heading? Plotting with missing data Regression Analysis Fun Chart 7 Dynamic chart: add new data and the chart expands. Linear Regression and Excel Index -- Jon Peltier's* Web Site -- Chart Pages
Graphing a Normal Distribution Curve in Excel
Graphing a Normal Distribution in Excel Chart Selector - Series Chart Selector II - Series Color Palette Conditional Chart Formatting Edit Chart Series Format chart Line Intercept Vertical Lines Label Last Point Make GIF Map Charts - USA Mu;tiple Chart Builder Waterfall Cahrt Zoom Chart Display multiple charts on a single Chart sheet Saving Chart as GIF Update charts automatically when you enter new data AutoChart Chart An Equation 1st Excel chart Box and Wisker Chart Chart Axes and Axis Tricks Chart Formatting Techniques and Tricks Chart Source Data Chart Types in Microsoft Excel Chart Wizard Charting Data From Different Sheets Charts for Statistics Combining Different Chart Types into a Single Chart Custom Chart Series Formatting Dynamic and Interactive Charts Error Free VBA Fun With Dummy Series Naming a Chart Protecting Charts in Microsoft Excel Quick Chart VBA Examples Resizing and Moving Charts in VBA VBA Charting Techniques Excel Charting FAQs Min and Max Points Avoid error displays in formulas Calculate the number of days in a month Creating a linked picture of a range
Author Andy Pope Andy Pope Andy Pope Andy Pope Andy Pope Andy Pope Andy Pope Andy Pope Bernard Liengme Bernard Liengme Bernard Liengme Bernard Liengme Bullen Bullen Clemson U Physics lab Contextures Excel Nexus Excel Nexus Ferrero Ferrero Ferrero Ferrero Ferrero Ferrero Ferrero Ferrero Ferrero Ferrero Ferrero Ferrero Ferrero J_Walk J_Walk J_Walk JKP JKP Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier Jon Peltier J-Walk J-Walk J-Walk
Creating Combination Charts J-Walk Handle missing data in a line chart J-Walk Transforming Data With Formulas J-Walk Handling Missing Data J-Walk Update charts automatically when you enter new data J-Walk Displaying a Chart in a UserForm J-Walk A Class Module to Manipulate a Chart SERIES J-Walk Chart Trendline Formulas J-Walk J-Walk Chart Tools J-Walk Hypocycloid Charts - WOW! J-Walk Time Line Chart ((Gantt) J-Walk Animated Line Chart Lacher Chart and Graph Tutorial Lacher Chart Controlled With Button Lacher Chart Controlled With List Box Lacher Plotting a Time Series of Data Lacher Plotting Zero and Missing (Empty) Values Lacher Using Custom Chart Markers in XY Chart Lacher Creating a chart which grows with your data Meadinkent SumProduct function: an alternative to arrays for conditional calculat Meadinkent Adding Series to XY (Scatter) Chart with Second X Axis Microsoft How to Change Chart Type of a Series in Combination Chart Microsoft How to change the color palette for workbooks in Excel 2002 or Excel 2003 Microsoft How to Copy Text to TextBoxes Using the Characters Method Microsoft How to Create a Chart with Discontiguous Ranges Microsoft How to Create a User-Defined Chart Format Microsoft How To Dynamically Create Excel 5.0 Charts in OLE 2.0 Control Microsoft How to Insert a Graphic File in Microsoft Excel Worksheet Microsoft How to use the Chart Wizard in Excel Microsoft HOW TO: Add Text to the X-Axis or Y-Axis on a Chart in Excel 2000 Microsoft HOW TO: Change the Chart Type of a Series in a Combination Chart in Excel 2000 Microsoft HOW TO: Consolidate Multiple Worksheets to a Single Sheet in Excel 2000 Microsoft HOW TO: Plot Values Against a Recommended Range in Excel 2000 Microsoft HOW TO: Rename a Chart by Using the Name Box in Excel 2000 Microsoft Macro to Extract Data from a Chart Microsoft Pivot Tables Microsoft Using Visual Basic to Create a Chart Using a Dynamic Range Microsoft XL: How to Create a Bell (Normal) Curve Chart Microsoft XL: How to Programmatically Print All Embedded Charts on a Worksheet Microsoft XL2000: How to Automatically Set Min and Max Scale for Y-Axis Microsoft XL2000: How to Programmatically Create a Chart Without Selecting a Range of Cells Microsoft XL2000: How to Use the ApplyCustomType Method to Format Charts Microsoft XL97: How to Control the Placement of Objects Microsoft XL97: How to Create a GIF File from a Microsoft Excel Chart Microsoft XL97: How to Trap Events for an Embedded Chart Microsoft Add a Trendline to a Chart Mr Excel Drag and Drop new Data Onto Chart Mr Excel Source Data Table - leave Left - Top Cell Blank Mr Excel Time on X Axis Mr Excel Dot Plots: A Useful Alternative to Bar Charts Naomi Robbins Step Chart Tushar Normal Distribution Curve Tushar Horizontal Line Tushar Vertical Waterfall Chart Tushar Normal Distribution Curve XL-Logic Dynamic chart: add new data and the chart expands. XL-Logic chart reference multiple data sources, user selects data source from a pullXL-Logic down menu. Dynamic chart 3 XL-Logic Performance Envelop XL-Logic Histogram XL-Logic Label Last Point XL-Logic
Synchronize the X and Y axes of an XY scatter chart
XL-Logic
ProcessTrends ProcessTrends ProcessTrends ProcessTrends ProcessTrends ProcessTrends ProcessTrends
Trend Chart Dynamic Chart Title Add Horizontal Line to Chart Add Vertical Line to Chart Build Control Chart Chart Cell Size Chart in a Cell Stacked XY Charts Highlight Min and max Points on Chart Missing Data Chart Animation Day of Year Trend Chart Comparison Excel's Camera Tool Range Names Importing Access Data into Excel Handling Formula Errors Date and Time in Excel Process Data Toolkit Data Scrubbing RSS Freeze Chart Text Size Size and Align Charts Chart List Chart object information Interactive Moving Average Chart Dynamic XY Axes - Control Min and Max Axis Values Excel Dashboard Sheet Layout
Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends Process Trends
Link http://www.andypope.info/charts/averageline.htm http://www.andypope.info/charts/brokenlines.htm http://www.andypope.info/charts/intersection.htm http://www.andypope.info/charts/conditionalline.htm http://www.andypope.info/charts/Labellast.htm http://www.andypope.info/charts/Scrolling.htm http://www.andypope.info/charts/stepchart.htm
http://www.andypope.info/charts/Labellast.htm
http://www.stfx.ca/people/bliengme/ExcelTips/Dynamic.htm http://www.stfx.ca/people/bliengme/ExcelTips/Document.htm http://www.stfx.ca/people/bliengme/ExcelTips/MissingData.htm http://www.stfx.ca/people/bliengme/ExcelTips/ExponentialTrendline&%20LOGEST.htm
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FunChrt7.zip http://www.bmsltd.ie/DLCount/DLCount.asp?file=FunChrt1.zip http://phoenix.phys.clemson.edu/tutorials/excel/regression.html
http://www.contextures.com/JPChartIndex.htm
http://www.vertex42.com/ExcelArticles/mc/NormalDistribution-Excel.html http://www.vertex42.com/ExcelArticles/mc/Files/NormalDistribution.xls http://www.edferrero.com/ChartSelector.zip http://www.edferrero.com/ChartSelector2.zip http://www.edferrero.com/ColourPalette.zip http://www.edferrero.com/CondFmt.zip http://www.edferrero.com/edseries.zip http://www.edferrero.com/ChartFormatLines.zip http://www.edferrero.com/Intercepts.zip http://www.edferrero.com/ChartPoints.zip http://www.edferrero.com/MakeGif.zip http://www.edferrero.com/MapUSA.zip http://www.edferrero.com/Multiple%20Chart%20Builder.zip http://www.edferrero.com/Waterfall.zip http://www.edferrero.com/ZoomChart.zip
http://j-walk.com/ss/excel/usertips/tip005.htm
http://j-walk.com/ss/excel/usertips/tip065.htm
http://j-walk.com/ss/excel/usertips/tip053.htm
http://www.jkp-ads.com/downloadscript.asp?filename=Autochrt.zip http://www.jkp-ads.com/downloadscript.asp?filename=ChartAnEquation.zip
http://peltiertech.com/Excel/ChartsHowTo/Charting101.html http://peltiertech.com/Excel/Charts/statscharts.html#BoxWhisker http://peltiertech.com/Excel/Charts/axes.html http://peltiertech.com/Excel/Charts/format.html http://peltiertech.com/Excel/ChartsHowTo/SourceData.html http://peltiertech.com/Excel/ChartsHowTo/ChartType.html http://peltiertech.com/Excel/ChartsHowTo/ChartWizard.html http://peltiertech.com/Excel/ChartsHowTo/ChartDataFromDifferentSheets.html http://peltiertech.com/Excel/Charts/statscharts.html http://peltiertech.com/Excel/Charts/ComboCharts.html http://peltiertech.com/Excel/ChartsHowTo/CustomSeriesFormatting.html http://peltiertech.com/Excel/Charts/Dynamics.html http://peltiertech.com/Excel/ChartsHowTo/ErrorFreeVBA.html http://peltiertech.com/Excel/Charts/DummySeries.html http://peltiertech.com/Excel/ChartsHowTo/NameAChart.html http://peltiertech.com/Excel/ChartsHowTo/ChartProtection.html http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html http://peltiertech.com/Excel/ChartsHowTo/ResizeAndMoveAChart.html http://peltiertech.com/Excel/Charts/chartvba.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#end http://peltiertech.com/Excel/Charts/FormatMinMax.html
http://j-walk.com/ss/excel/usertips/tip010.htm http://j-walk.com/ss/excel/usertips/tip047.htm http://j-walk.com/ss/excel/usertips/tip039.htm
http://j-walk.com/ss/excel/usertips/tip078.htm http://j-walk.com/ss/excel/usertips/tip024.htm http://j-walk.com/ss/excel/usertips/tip072.htm
http://j-walk.com/ss/excel/usertips/tip024.htm http://j-walk.com/ss/excel/usertips/tip053.htm http://j-walk.com/ss/excel/tips/tip66.htm http://j-walk.com/ss/excel/tips/tip83.htm http://j-walk.com/ss/excel/tips/tip101.htm http://j-walk.com/ss/excel/files/charttools.htm http://j-walk.com/ss/excel/files/hypocycloid.htm http://j-walk.com/ss/excel/files/timeline.exe
http://www.lacher.com/examples/lacher12.htm http://www.lacher.com/toc/tutchart.htm http://www.lacher.com/examples/lacher14.htm http://www.lacher.com/examples/lacher31.htm http://www.lacher.com/examples/lacher40.htm http://www.lacher.com/examples/a960524a.htm http://www.lacher.com/examples/960525a.htm http://www.meadinkent.co.uk/xlgraphoffset.htm http://www.meadinkent.co.uk/xlsumproduct.htm http://support.microsoft.com/default.aspx?scid=kb;en-us;115073 http://support.microsoft.com/default.aspx?scid=kb;en-us;192641 http://support.microsoft.com/default.aspx?scid=kb;en-us;288412 http://support.microsoft.com/default.aspx?scid=kb;en-us;148815 http://support.microsoft.com/default.aspx?scid=kb;en-us;146058 http://support.microsoft.com/default.aspx?scid=kb;en-us;142124 http://support.microsoft.com/default.aspx?scid=kb;en-us;147803 http://support.microsoft.com/default.aspx?scid=kb;en-us;142133 http://support.microsoft.com/default.aspx?scid=kb;en-us;304421 http://support.microsoft.com/default.aspx?scid=kb;en-us;213958 http://support.microsoft.com/default.aspx?scid=kb;en-us;213881 http://support.microsoft.com/default.aspx?scid=kb;en-us;214270
http://support.microsoft.com/default.aspx?scid=kb;en-us;211938
http://support.microsoft.com/default.aspx?scid=kb;en-us;212121 http://support.microsoft.com/default.aspx?scid=kb;en-us;137016 http://support.microsoft.com/default.aspx?scid=kb;en-us;142589 http://support.microsoft.com/default.aspx?scid=kb;en-us;146055 http://support.microsoft.com/default.aspx?scid=kb;en-us;213930 http://support.microsoft.com/default.aspx?scid=kb;en-us;213460 http://support.microsoft.com/default.aspx?scid=kb;en-us;213644 http://support.microsoft.com/default.aspx?scid=kb;en-us;213352 http://support.microsoft.com/default.aspx?scid=kb;en-us;213521 http://support.microsoft.com/default.aspx?scid=kb;en-us;168651 http://support.microsoft.com/default.aspx?scid=kb;en-us;163103 http://support.microsoft.com/default.aspx?scid=kb;en-us;161858 http://www.mrexcel.com/tip067.shtml http://www.mrexcel.com/tip024.shtml http://www.mrexcel.com/tip056.shtml http://www.mrexcel.com/tip032.shtml
http://www.b-eye-network.com/view/index.php?cid=2468&fc=0&frss=1&ua= http://tushar-mehta.com/excel/charts/step_chart/ http://tushar-mehta.com/excel/charts/normal_distribution/ http://tushar-mehta.com/excel/charts/straight_lines/ http://tushar-mehta.com/excel/charts/waterfall/index.htm http://www.xl-logic.com/xl_files/formulas/distrib.zip http://www.xl-logic.com/xl_files/charts/dynamic_chart_1.zip http://www.xl-logic.com/xl_files/charts/dynamic_chart_2.zip http://www.xl-logic.com/xl_files/charts/dynamic_chart_3.zip http://www.xl-logic.com/xl_files/charts/envelope.zip http://www.xl-logic.com/xl_files/charts/histogram.zip http://www.xl-logic.com/xl_files/charts/label_chart.zip
http://www.xl-logic.com/xl_files/charts/xy_sync_chart.zip http://processtrends.com/pg_charts_trend_chart.htm http://processtrends.com/pg_chart_dynamic_chart_title.htm http://processtrends.com/pg_charts_horizontal_line.htm http://processtrends.com/pg_charts_vertical_line.htm http://processtrends.com/pg_charts_control_chart.htm http://processtrends.com/pg_charts_cell_size.htm http://processtrends.com/pg_charts_chart_in_cell.htm http://processtrends.com/pg_charts_stacked_XY_Charts.htm http://processtrends.com/pg_charts_min_max.htm http://processtrends.com/pg_charts_missing_data.htm http://processtrends.com/pg_charts_xy_trend_animation.htm http://processtrends.com/pg_charts_DOY_trend_comparison.htm http://processtrends.com/pg_charts_camera_tool.htm http://processtrends.com/TOC_Excel_data.htm#Range%20Names http://processtrends.com/TOC_Excel_data.htm#Importing_Access_Data_Into_Excel_ http://processtrends.com/TOC_Excel_data.htm#Formula%20Errors http://processtrends.com/TOC_Excel_data.htm#Date_and_Time_(DT)_Formulas_In_Excel http://processtrends.com/TOC_pdtk.htm http://processtrends.com/TOC_pdtk.htm http://processtrends.com/rss.htm http://processtrends.com/pg_chart_vba.htm#Freeze_Text_Font_Size http://processtrends.com/pg_chart_vba.htm#Size_Align_Charts http://processtrends.com/pg_chart_vba.htm#Chart%20List http://processtrends.com/pg_chart_vba.htm#Chart_Object_Information http://processtrends.com/pg_charts_moving_avg_chart.htm http://processtrends.com/pg_charts_set_x_axis_min__max_dates.htm http://processtrends.com/TOC_pdtk.htm
Jon Peltier Andy Pope Bernard Liengme Tushar medhta AppsPro Excel User John Lacher Kelly O'Day ExcelUser Stephen Few
Jon Peltier's Excel Charts AJP Excel Information - Charts Bernard's Excel Tips http://tushar-mehta.com/excel/charts/ Application Professionals ExcelUser -- Excel Charts Chart and Graph Tutorial Excel Charts ExcelUser -- Getting Started With Excel Dashboard Reporting Perceptual Edge The Work of Edward Tufte and Graphics Press Gallery of Data Visualization Contextures Ferrero Consulting Pty Ltd Clemson U. Physics Excel Tutorial The Excelets Page Excelets are Applets made with Excel http://www.trinity.edu/rjensen/dhtml/excel01.htm
Tufte
Gallery of Data Visualization Contextures Ed Ferrero Clemson U Physics Lab EXCELETS - Animation Bob Jenson, Trinity University
http://peltiertech.com/Excel/Charts/index.html http://www.andypope.info/charts.htm http://www.stfx.ca/people/bliengme/ExcelTips.htm http://tushar-mehta.com/excel/charts/ http://www.appspro.com/Utilities/ChartLabeler.htm http://www.exceluser.com/help/chart/long001.htm http://lacher.com/toc/tutchart.htm http://processtrends.com/TOC_Excel_charts.htm http://www.exceluser.com/dash/startdash.htm http://www.perceptualedge.com/index.htm http://www.edwardtufte.com/tufte/ http://www.math.yorku.ca/SCS/Gallery/ http://www.contextures.com/excelfiles.html#DataVal http://www.edferrero.com/Charting.aspx http://phoenix.phys.clemson.edu/tutorials/excel/index.html http://guava.cites.uiuc.edu/l-arvan/ExceletsWeb/Descriptions.htm http://www.trinity.edu/rjensen/dhtml/excel01.htm