How to Improve Your Iris Model

Three Parts:Modify the Old ChartSet up Inner Iris Fiber Data SeriesCreate the Secondary Fibers Chart

You will improve upon the work started in the article Model Your Own Iris in Excel. If you have yet to do that one, it is a prerequisite for starting this one, so please do it first. Here, you'll achieve a more realistic blue eye, complete with the "behind, secondary layer" of iris fibers, in full detail.


  • Become familiar with the basic image to be created:
  1. 1
    Access the spreadsheet you used for the article Model Your Own Iris in Excel and re-name and re-save it under a new name, something like "Model Your Own Iris in Excel.2". and file it within a logical folder such as "wikiHow Articles" or "Microsoft Excel Imagery".
    • Freeze panes at Q4.
  2. 2
    Build the above image by following these steps.

Part 1
Modify the Old Chart

  1. 1
    • Select the following series with red or yellow glow or red or yellow lines and change the red to blue: Series 93/94 at about 270 degrees, Series 51/52 at about 165 degrees, etc., but leave a few on the lower right and one nearly straight up. You may need to temporarily move the flash reflection out of the way. Put it back when done.
    • Go around the entire chart, selecting each series in turn, and set glow to either None or 2 with 50%. No exceptions. Eliminate most red and yellow glow but leave white.
    • Set the Fill for the Plot Area to Gradient 11% Black, 16% White, 23% Steel Blue, 41% Steel Blue, 51% White, 54% Mid-dark Grey, 76% White, 83% White, 86% Blood or Maroon Red, 97% Dark Salmon/Flesh Orange-Pink-Red (Burnt Orange).
    • Set line weight for Series 1 (Circumference) to 25 and Gradient to 37% Black, 86% Midnight Blue (from the Color Wheel), and 100% White.
  2. 2
    Construct the Looker vlookup table.
    • Enter Looker into cell IM1;
    • Enter 1 into cell IN1and Format Cells Font Red Bold, Fill Yellow, Border Bold Red Outline;
    • Enter 1 into cell IM2 and select cell range IM2:IM11 do Edit Fill Series, accept Step Value 1, OK -- to create a series from 1 to 10.
    • Enter 1.007 to cell IN2 and Insert Define Name Key_1 to cell $IN$2; Format Cells Fill Light Blue;
    • Enter to cell IN3 the formula, =-Key_1+IN1*2, and Insert Define Name Key_2 to cell $IN$3; Format Cells Fill Sand color;
    • Enter to cell IN4 the formula, =Key_1; Copy this formula and paste it to cells IN6, IN8 and IN10.
    • Enter to cell IN5 the formula, =Key_2; Copy this formula and paste it to cells IN7, IN9 and IN11.
    • Select cell range IM2:IN11 and Insert Define Name Looker to cell range $IM$2:$IN$11.
  3. 3
    Cut (command x) the ShrinkExpand sections at cell range G16:H22 and paste to cell IP4.
  4. 4
    Select both the picture and the chart and drag them straight down about 25 rows.
  5. 5
    Enter Modifier
    • Enter to cell F16, Modifier;
    • Insert Name Define Modifier to Row 16.
    • Select cell G16 and input the formula, =VLOOKUP(RANDBETWEEN(1,10),Looker,2)
    • Copy cell G16 to cell range H16:IL16.
    • Select cell range G2:IL2 and do Edit Replace =$ with =Modifier*$, Replace All, OK.

Part 2
Set up Inner Iris Fiber Data Series

  1. 1
    • Select cell range E1:IL16 and copy it. Paste it all to cell E22.
    • Select cell range F26:F35 and Insert Define Name Degrees2 to it. Enter Degrees2 to cell F25.
    • Select cell range Row 26 and Insert Define Name STARTPTS to it. Enter STARTPTS to cell E26.
    • Select cell range E27:E33 and Insert Define Name Peeces to it. Format Cells Number Number Custom "Peeces "0.0000 to cell range E27:E33.
    • Enter to cell E34, ENDPT2. Insert Define Name ENDPT2 to cell F34.
    • Enter to cell E35, DIFFS. Insert Define Name DIFFS to Row 35.
    • Input the formula =(ENDPT2-STARTPTS)/7 to cell F35.
    • Input 90 to cell F34 and Format Cells Fill light blue.
    • Input the formula =PI()/4 to cell E27 and Format Cells Fill light blue.
    • Enter the formula, =G2 to cell G24 and copy it and Edit paste special formulas to cell range H24:IL24. Format Cells Font Color Red Bold for cell range E24:IL24.
    • Format Cells Font Color Dark Blue for cell range E23:IL23.
    • Format Cells Font Color Dark Blue for cell range E26:IL26.
    • Format Cells Font Color Red for cell range E34:IL34.
    • Input the formula, =IK1+1, to cell G22
  2. 2
    Do the Formula Replacements for the Secondary Iris Fibers:
    • Select cell range G27:IL33 and do the following EDIT REPLACES:
      • Replace DIFF with DIFFS, Replace All, OK;
      • Replace STARTPT with STARTPTS, Replace All,, OK;
      • Replace Pieces with Peeces, Replace All,, OK; and
      • Replace Degrees with Degrees2, Replace All,, OK.
  3. 3
    Modify the Secondary Iris Fibers Start Points, x and y:
    • Input Modifier2 to cell F37.
    • Input Percentage to cell F38. Set cell G38 to .8 for now, but finally to .97 -- don't forget. The reason you want it at .8 now is that it makes it easier to find the series "sticks" that Excel mis-plots off to the right side of the chart, which you need to click on, but can otherwise be very very tiny. In the meantime, you will get some long, out of place iris fibers; do not let that deter you as you will easily fix it later by changing Percentage to .97
    • Enter to cell G37 the formula =VLOOKUP(RANDBETWEEN(1,10),Looker,2)*Percentage and copy it and paste it to cell range H37:IL37.
    • Insert Name Define Modifier2 to Row 37.
    • Edit Replace in cell range G23:IL23 =$ with =Modifier2*$

Part 3
Create the Secondary Fibers Chart

  1. 1
    Select the data area equivalent to G26:H34 for each lower series from #123 in row 22 to Series #242 (columns IK and IL)(charting range IK26:IL34), and copy it and double-click in the chart's inner plot area of the iris and do command v paste, then edit the series formula in the formula bar until it becomes like these first three:
    • =SERIES(,'Circle Data and Chart'!$G$26:$G$34,'Circle Data and Chart'!$H$26:$H$34,2)
    • =SERIES(,'Circle Data and Chart'!$I$26:$I$34,'Circle Data and Chart'!$J$26:$J$34,123)
    • =SERIES(,'Circle Data and Chart'!$K$26:$K$34,'Circle Data and Chart'!$L$26:$L$34,124) all the way up to the last one:
    • =SERIES(,'Circle Data and Chart'!$IK$26:$IK$34,'Circle Data and Chart'!$IL$26:$IL$34,241)
    • You'll note that the series number of the first one is 2 instead of 123 or 122 and that's because at one point I tried tucking it under via order arrangement the top or frontmost iris fiber layer -- so just ignore that, please.
    • Be aware that this last process takes a bit of time. -- about 6-8 hours in this author's experience. Also, the line weight is a matter of personal discretion and this author chose to see some space between individual fibers and so chose a line weight of .75 or 1, but bonding of the fibers at the pupil's edge might be improved either with some constant glow or a slightly greater line weight.
  2. 2
    Above is the image of my best final effort. It includes the following revisions:
    • ShrinkExpand = 20, X_Offset = 20, Y_Offset = 20, ShrinkExpand2 = 4, X_Offset2 = 20, Y_Offset2 = 20;
    • The Vertical Axis Scale has a Minimum of -2 and a Maximum of 42; the Horizontal Axis Scale has a Minimum of -2 and a Maximum of 43; the Chart measures 10.0 by 10.0;
    • The Gradient of the Main External Circle has Darker Blue Sky at 3% and 59%, White = 63%, Very Dark Navy Blue = 68%;
    • The Fill for the Plot Area Gradient = Very Dark Navy Blue = 16%, White = 18%, Darker Blue Sky (a pickable color) = 25% + 36%; Medium Blue = 47%, Dark Blue = 57%, White = 64% + 83%, Dark Red Blood = 86%, Burnt Orange/Flesh = 97%;
    • The workbook was renamed "Model Your Own Iris In XL.3.xlsx"; Row 2 values from G2:IL2 were pasted in per a new data worksheet showing the original photo of an actual eye in large closeup on a worksheet named 'Big Baby Blue', with the following data chit using the variables Expander and XYadj to adjust the standard Cos and Sin row formulas:
    • The Cos formula in cell BB4 of that worksheet is =Expander*COS((ROW()-4)*PI()/180)+XYadj and the Sin formula in bottommost rightmost cell CG364 is =Expander*SIN((ROW()-4)*PI()/180)+XYadj;
    • Those columns set up a series of rings;
    • 30ยบ lines were added via the following data chit:

      30 Degree Lines
    • Those applied to the original data set in columns K:AQ -- here is the image of the Expander and XYadj settings for that portion:
    • Together, the following image was assembled, using the actual iris photo as chart background:
    • Per that image and the data table, Row 2 G2:IL2 values were changed of "Model Your Own Iris In XL.3.xlsx" per pasted in values, as copied from the BB:CG cell range of Big Baby Blue;
    • A white triangle and white 5 pt weight line were added from Media Tools to the upper right of the Plot Area to block that portion of the "flesh" showing, and were very carefully placed.
  3. 3
    Here is the Final Best Image produced from that process:


  • When you're done, go back and reset percentage to .97
  • Move the photo lamp reflection back into place and you can brighten that using Format Picture and setting it to be a little less transparent helps also.
  • You can re-do the Chart background if you like, in the same gradient as the Plot Area Fill.
  • These images are available for purchase at

Sources and Citations

Article Info

Categories: Graphics | Microsoft Excel Imagery