Tutorial 2: Convert a Column Chart to data

This tutorial shows how to convert a column chart to data. First start the Chart2Data App and click / tap on the Bar / Column Chart Icon. The tutorial is shown in expert mode (dark blue background). If you start Chart2Data for the first time the app is in Wizard mode by default (dark purple background). You can change the user mode in the App settings. Note: in case you change the user mode during a chart conversion process the new setting will be saved but will not be active since the user mode cannot be changed during a chart conversion process. The new setting will become active once you reach the start page again and choose a chart category.

Chart2Data_Screenshot_1

First open an Image by clicking / tapping on the large folder icon in the image area. You can find the image used for this tutorial in the downloads section. The filename of the image is:

column_Chart.jpg

tutorial_2_1

Note: using the small folder icon you can reload another image, in case you realize that you have opened the wrong image by mistake. Your screen should now look like this:

tutorial_2_1b

Now click / tap the edit-box called Px. coord. y (lower corner data area) to highlight it.

tutorial_2_2Zoom into the lower left corner by using the two-fingered touch gesture or the Ctrl-Key plus mouse-wheel. Next click /tap the lower left corner of the data area in the chart (in this case it’s the origin of the chart) in order to transfer the pixel coordinates into the corresponding edit-box. Note: In case you would like to exactly reproduce the results of this tutorial, you have to make sure that you pick the same y-coordinate as shown in this tutorial.

tutorial_2_3

Then click / tap the edit-box called Px. coord. y (upper corner data area) to highlight it.

tutorial_2_4

Zoom into the upper left corner by using the two-fingered touch gesture or the Ctrl-Key plus mouse-wheel. Next click /tap the upper left corner of the data area in the chart in order to transfer the pixel coordinates into the corresponding edit-box. Note: In case you would like to exactly reproduce the results of this tutorial, you have to make sure that you pick the same y-coordinate as shown in this tutorial.

tutorial_2_5

Let’s continue with setting the limits of the y-scales. We start with lower limit value of the y-scale. Click / tap the edit box called y-Value (lower limit scale) and set it to “0” using the (Onscreen-)Keyboard.

tutorial_2_6

Note: for this chart we do not have to worry about the pixel coordinates of the lower y-scale limit (edit-box Px. coord. y (lower y-scale limit)) because this pixel coordinate coincides with the pixel coordinate of the lower left corner of the data area. This pixel coordinate needs only to be set if both pixel coordinates do not coincide (see figure below).

y_lowerPixel_edit_explain

Now we set the upper scale limit of the y-axis accordingly to “14”.

tutorial_2_7

So now we are done with the first part. Click the Next button (arrow to the right) in the upper right corner of your screen.

tutorial_2_7b

Then your screen should look like this:

tutorial_2_7c

We leave the y-axis scaling options untouched, since we have a linear y-scale and the check-box linear is already checked. We also have already set the correct scale limits. The last task we have to do before converting the chart is to select one pixel from the top row of pixels of each column. It does not matter which pixel you choose horizontally, because only the y value of the pixel coordinates matters. This value is equivalent to the height of the column which is proportional to the column value.

Zoom in on the first column on the left and click / tap on one pixel of the column’s top row. The coordinates show up in the List to the right of the image. Note: In case you would like to exactly reproduce the results of this tutorial, you have to make sure that you pick the same y-coordinates as shown in this tutorial for each column. If you have made a mistake selecting the correct pixel, you can easily remove coordinates from the list by clicking / tapping on the ones you want to have removed.

tutorial_2_8

Then zoom in on the next column to the right and click / tap a pixel of the column’s top row. Again the coordinates show up in the list as additional point.

tutorial_2_8b

Now repeat this process for the 6 remaining columns.

tutorial_2_8c

So, now we are done with providing Chart2Data with all the necessary information. Click / Tap on the Next button to start the conversion process.

tutorial_2_8d

When the conversion process is finished, a screen appears prompting for a filename of the output file.

tutorial_2_9

After providing a filename for the output file, the Results Screen appears showing the values of the converted columns indexed from left to right.

tutorial_2_10