## Introduction: Make Digital/truth Table Graphs in Excel

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.

### Attachments

### 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

1

1

2

2

3

3

.

.

.

Now for the rest of the column just copy each data twice.

Such as for the clock

0101010101...

becomes

0011001100110011...

starting from 0

Do the same for all the other data series.

just for an example

010001

becomes

001100000011

## 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

Min=0

Max=1.2

Horizontal is

Min=0

Max=16

## 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.

### Attachments

Participated in the

Full Spectrum Laser Contest

Participated in the

Data Visualization Contest

## Discussions

2 years ago

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