Like a child selecting parts to construct a Lego model engineers bring together blocks of science to create new designs. These building blocks could be a load calculation, a beam calculation, a weld calculation, a fatigue calculation or any other calculation from a myriad of engineering topics. As...
The site is optimised for browsing on mobile devices like the iPhone or Android phones. To create a web app icon browse to http://www.excelcalcs.com/navigate/ and ‘Add to Home Screen’. You will find an icon much like an app icon on your home screen which will bring you straight back...
I have been chasing up feedback from new users signing up to XLC Pro accounts in the last month. I am delighted with their positive feedback. “I started using XLC but I am now insisting that my whole team use the add-in .“ “It is a great tool for validation and pres...
Engineering training - “I run a team of engineers and whilst there are plenty of soft options for training expounding the latest management techniques there is precious little to develop the engineering skills of my team”. This is a familiar story we hear from clients of our trai...
You are probably familiar with our tools of mass knowledge distribution on our website but ExcelCalcs also works more closely with corporate partners providing engineering training and engineering consultancy services. What’s more these services and ExcelCalcs subscriptions are availa...
ExcelCalcs eFormulas aims to replace traditional engineering formula books providing innovative functionality to copy from our webpages and paste directly into Excel. Once in Excel it is easily edited to suit your own problems this functionality is far more flexible than 'stuck on the web'&n...
At some time or other you will have been given someone else’s spreadsheet only to be left scratching your head not having a clue as to what the calculation is doing. If you are wise you will not use it because you can’t understand it. If you are wiser still you’ll use our...
In our good calculation guide we emphasise the importance of sketches in calculations but you can produce interactive 3D wireframe sketches by incorporating Turan Babacan’s latest upload. Turan uses 3D charts to great effect in his Excel FEM programs. Andy Pope also has a 3D chart spr...
A new version of XLC is in the final stages of development which will be compatible with the 64 bit version of Excel 2010 (currently it works with the 32 bit version of Excel 2010, 2007 2003 and 2000). We’ll keep you posted with progress. Please send us details of any features you ...
This is an adaptation of Andy Pope’s 3D scatter chart. I have used it to plot a 3D Helix. I think this chart may be of particular use to ExcelCalcs users but see the list of links to his website and other custom charts below.
For anyone interested in how Andy uses matricies to produce the 3D chart you might also wish to look at
transformation matrix.xls
Version History
Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.
Banding plot area on bubble chart
VBA code to align plot area of 2 charts
A conditional line chart based on formula
Add-In for applying Pattern fills to charts and shapes in XL2007
User Defined Functions to calculate intersections between lines and circles
Size pie charts plotarea
Highlight axis labels
Polar plots
Pie slice radius
Add data values to High-Low line
Colour xy scatter points
Automatically updating custom leader lines
Axis label alignment when charting positive and negative bars
Creating bounding area within xy scatter
Use a pie chart as a data marker
Display pointer at end of axis
Display a cumulative total on a stacked column chart
An step by step explanation on how to control the Invert if Negative property
An explanation of how to delete a single legend entry
Last last point in a chart using dummy data series
Dynamic scrolling through data
Alternate conditional dual category plot
Conditional dual category plot
An add-in to help create polar charts. Plus an workbook which contains examples of polar plots
Various methods to create staggered axis labels
Various ways and chart types that can be used to create a stepped line
Column chart that has variable width bars, including a stacked style
Split a graphic into variable width sections
An alternative to zero or joined points
A pie chart that does not display zero values
Pie On Pie; Pie By Pie and Filled Doughnut chart
Column chart that has variable width bars
A work around for multiple images in a pie chart
A worked example of a clustered column chart with a floating gap column
A worked example of a column chart with a break in the value axis. Display data with large variance between min and max values
A worked example of a conditional chart
A worked example of Side by Side stacked column chart. Extended to handle xl97 category label limitations
A worked example of 2 sets of stacked bars with different widths
Average line on chart. A collection of methods and charts styles
Floating bar chart with the bars clustered
Thermometer style charts
Matrix of mini xy scatter plots
Stacked positive and negative bar chart with series order maintained
Change the colour of a line as it passes above or below a fixed datum line
Simulated 3d XY scatter
Mark the points of intersection between two lines
A speedo style chart
Total Votes:0| Membership |
© 2007 - 2012 MoreVision Ltd. All Rights Reserved. |
Conditions of use . |
US +1 617 5008224
Toll Free:
