Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Latex Maths Text in Excel
- Commenting a block of code in VBA
- Cubic Splines
- Removing Add-ins
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Solving cubic and quartic equations with Excel
- Retrieving unique values from a range or array ...
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
Recent Comments
Tag Archives: Drawing
Drawing in Excel 8 – scaling and trimming
Previous Post – Drawing in Excel 7 Download PlotXY-xls.zip (XL 2003 and earlier) Download PlotXY-xlsb.zip (XL 2007) The previous post presented VBA routines to plot drawings in Excel from a series of coordinates, a list of connected points, and a … Continue reading
Drawing in Excel 7 – Creating drawings from coordinates
Previous Post, Drawing in Excel 6 The file PlotXYcontains routines to plot scale drawings in Excel from a list of XY coordinates of node points, node points for each shape, and formatting details for each shape type. The plot is scaled … Continue reading
Drawing in Excel 6 – getting shape properties
Previous post One of the less than useful new “features” of Excel 2007 is that its macro recorder no longer records operations on shapes, which removes the easiest way to discover the exact names of shape properties, and how to manipulate … Continue reading
Drawing in Excel 5 – Shape List
Previous Post For some reason best known to Microsoft, the Excel documentation does not include a graphic list of shapes with an example of each shape, and the text list they do provide is incomplete. The file shapelist.zip rectifies that … Continue reading
Drawing in Excel-4
This post will look in a bit more detail at the methods presented in the previous post. It would be a good idea to open the previous post on another tab, or download the example file and open the code … Continue reading