Holarch
Course chapters

Training · Track 13. Whiteboards · Chapter 13.3 of 4

13.3 Charts 3:32

Insert charts, give them data, change their type, select their data, format their axes and import charts from Excel.

Shows Holarch 2.35.

What you’ll learn

  • Insert a chart and give it data in Chart Data, typed, pasted or imported from a file
  • Change the chart type, including stacked and 100% stacked
  • Switch rows and columns and order series in Select Data
  • Turn chart elements on and set axis bounds and units in Format Axis
  • Import charts from an Excel workbook

Add a board of usage charts to the Bike-Share Dock concept whiteboard: insert a column chart, edit its data and import the rental figures from an Excel sheet, switch it to a stacked column chart in the Change Chart Type gallery (with the 100% stacked, bar, line, pie, donut and scatter previews), reorder and switch series in Select Data, turn on data labels and move the legend in Chart Elements, set the value axis bounds and units in Format Axis, and import a line chart and a pie chart from an Excel workbook with Import Chart from Excel.

Project files

  • Starting project (.holarch.json; Manage Projects → Project Files ▾ → Import Project (.json)…)
  • Finished project (.holarch.json; Manage Projects → Project Files ▾ → Import Project (.json)…)

The video plays from holarch.app; see the Privacy Policy.

Practice

Do this yourself in Holarch, on Bike-Share Dock.

  1. Open the chapter's starting file and the Dock Concept whiteboard. Click + in the Boards strip.
  2. Open Tables and Charts and click Column. Double-click the chart, click Import from File… and choose a workbook of your own with a label column and two number columns.
  3. Right-click the chart → Change Chart Type… → Stacked Column → OK.
  4. In the Chart section, click Select Data…, try Switch Row/Column twice, move a series up and click OK.
  5. Tick Data labels, set the legend to Top, click the value axis and set Maximum and Major.
  6. Click Import Chart from Excel… and insert a chart from a workbook that has charts.

You're done when the board has a stacked column chart with data labels, a legend on top and fixed axis bounds, and one chart imported from Excel.

Check yourself

  1. When is a 100% stacked chart better than a stacked one?
  2. What does Switch Row/Column do?
  3. How do you go back to an automatic axis bound after setting one?
Show the answers
  1. When is a 100% stacked chart better than a stacked one?

    When the shares matter more than the totals: each bar fills the height, and the segments show each series' part.

  2. What does Switch Row/Column do?

    It swaps series and categories: the rows become the series and the columns the categories, or the other way round.

  3. How do you go back to an automatic axis bound after setting one?

    Empty the box in Format Axis.

Read more

Transcript

Show the transcript (narration and what is on screen)

Introduction

Chapter three: charts. A whiteboard chart draws its own data, which you type, paste or import, and you format it the way you would in a spreadsheet.

In this chapter you build a board of usage charts for the dock.

A chart and its data

The charts get a board of their own. Click the plus in the Boards strip under the board: the new board opens as a second tab.

On screen: Boards strip → +.

Open the Tables and Charts panel, and click Column. The chart is added in the middle of the view, with sample data.

On screen: Tables and Charts panel → Column.

Double-click the chart to open Chart Data. Labels go in the first column and series names in the first row. You can type in the grid, add rows and series, or paste rows copied from a spreadsheet.

On screen: Double-click the chart → Chart Data.

Our rental figures are in a workbook. Click Import from File, and choose Dock Usage.

On screen: Import from File… → Dock Usage.xlsx.

The workbook has three sheets. Choose Rentals. The preview shows six months and two series, weekday and weekend. Click Use Imported Data, then Done.

On screen: Sheet: Rentals → Use Imported Data → Done.

Chart types

Right-click the chart, and choose Change Chart Type. The gallery shows your own data in every type.

On screen: Right-click → Change Chart Type….

Stacked column stacks each month's series, so the bar shows the total. One hundred percent stacked compares the shares. Bar turns the chart on its side, and line, pie, donut and scatter are here too.

On screen: Gallery: Stacked Column, 100% Stacked Column, Bar, Line, Pie, Donut, Scatter.

Choose Stacked Column, and click OK.

On screen: Stacked Column → OK.

Select Data

Select Data, in the Chart section, chooses what the chart shows. Switch Row and Column turns the months into the series and the series into the categories. Switch it back.

On screen: Chart section → Select Data… → Switch Row/Column, twice.

Legend entries lists the series. Select Weekend, and click Move Up: weekend now sits at the bottom of each stack, and keeps its color. Click OK.

On screen: Weekend → Move Up → OK.

Format the chart

Chart Elements turns the parts of the chart on and off. Tick Data labels, and set the legend position to Top.

On screen: Chart Elements → Data labels; Legend position: Top.

Click the numbers of the value axis to select the axis. A dashed box marks it, and the inspector shows Format Axis.

On screen: Click the value axis.

Set the maximum to three thousand, and the major unit to five hundred. Leave a box empty for automatic. Every change is one undo step.

On screen: Format Axis: Maximum 3000, Major 500.

Import charts from Excel

Charts made in Excel come in too. In the Tables and Charts panel, click Import Chart from Excel, and choose the workbook.

On screen: Import Chart from Excel… → Dock Usage.xlsx.

The dialog lists every chart in the workbook, with a preview, its sheet, its type and its series, and says what does not carry over. Tick the line chart and the pie chart, and click Insert.

On screen: Tick the line and pie charts → Insert 2 Charts.

They arrive selected, as whiteboard charts with their titles, colors and axes. Drag them below the first chart. You edit and format them like the one you made.

On screen: Drag the imported charts below the column chart.

Recap

To recap: insert a chart from the Tables and Charts panel, give it data in Chart Data, choose its type in the gallery, set its series in Select Data, format it with Chart Elements and Format Axis, and import charts from Excel.

In the next chapter, you link charts and tables to live spreadsheet cells, connect the board to the model and add clipart.