Make Digital/truth Table Graphs in Excel

Introduction: Make Digital/truth Table Graphs in Excel

About: I am a hobist with lots of hobies from carpentry to mechanics. There is hardly any thing that i am not interested in.

How many times have you tried making a digital graph for truth tables on excel? I have tried innumerable times thinking that excel is useless! Now I can finally say that I can make one quite easily from a truth table or digital data.

Teacher Notes

Teachers! Did you use this instructable in your classroom?
Add a Teacher Note to share how you incorporated it into your lesson.

Step 1: Put the Data

Enter some data of the table. I am using 16 data i.e. 2 to the power of 4. there will be a clock cycle, 2 data sets A and B and one manipulated/derived data A OR B. Data name is put just to use it while drawing the data.
Using an IF statement for the derived data because using an OR gives us TRUE or FALSE which is much unusable.

Step 2: Manipulate the Data for Drawing

This is the most important part. This part defines how the table will be drawn.
Start with the Data Name. Put a 0 at the start. Now start putting all the data in the Data name. Use each number twice.
such as

Now for the rest of the column just copy each data twice.
Such as for the clock
starting from 0
Do the same for all the other data series.

just for an example

Step 3: Chart It

Now by selecting the Data name column and clock create a scatter chart.
Same way create scatter charts with the Data Name and other columns.
Edit the charts to make them of the same size.

Step 4: Standardize It

Now standardize the vertical columns and horizontal columns of all the charts of same.
Such as
Vertical is

Horizontal is

Step 5: Smooth It Out

Remove the check box named Smoothed line to get a digital graph look from all the graphs. See the image for the detail.

Step 6: Final Touches

Remove the Legend, vertical and horizontal indents. This is optional and can be used if required.

Step 7: Decoration

Finally color each graph to separate them in looks. The lines can be thickened. You can add dotted lines if required and many more decorations.

Thus your digital graph is ready to be showcased.
added is the excel that I used for this ible. Use it to further understand the scenario. Feel free to comment if need help or want to say something.

Full Spectrum Laser Contest

Participated in the
Full Spectrum Laser Contest

Data Visualization Contest

Participated in the
Data Visualization Contest

Be the First to Share


    • LED Strip Speed Challenge

      LED Strip Speed Challenge
    • Sculpting Challenge

      Sculpting Challenge
    • Tiny Speed Challenge

      Tiny Speed Challenge



    2 years ago

    Thanks! I saved I lot of time for my new tutorial! :)