More Fun Chart Hacks in Canva

I bring you more chart hacks in Canva!

Canva has a number of simple chart designs that you can adapt to your needs. After starting a design in Canva, click on “Elements” and then type in “chart” in the search window to see the chart options shown in the image to the right. Each allows you to customize the chart by entering in a few data points.

HERE are some ways that I have shared in the past to use other options in Canva to hack out some fun charts. And below, you’ll find a few more ideas.

Chart Hacks

Start a design in Canva by clicking on the “Create A Design” button (upper right corner of screen), selecting a size (such as presentation), and then try one of my hacks.

HACK 1: Place a chart in a landscape: For this bar chart hack, find a landscape by searching in “Elements” (on left side of screen). Landscapes with large, cloudless skies work best. Drag the image onto a page and size it as you like. With the image selected, click on “Edit Image” in the upper left corner of the design area and then use the Background Remover tool to remove the sky. Now create a chart using the chart tools (see above). With the chart selected, click on “Position” in the the upper right corner of the design area and select “Backward” to put the chart sligtly behind the landscape image. (See how the bottoms of the bars in the image below are behind the hills?) Finally, find a sky image by searching in “Background” (on left side of screen) and add it to the design.

HACK 2: Show change over time in a chart “notebook.” For this chart, I created a series of donut charts using the chart tools (see above). Then I found a notebook graphic in “Elements.” I made several copies of the graphic and added the charts and labels to each page of the notebook.

HACK 3: Use number frames to label a key data point. For this chart, I created a line graph using the chart tools (see above). Then I searched for “number frames” in “Elements.” I added the relevant numbers to label the key data point on the graph and then dragged and dropped photos into the the number frames. Note that you can upload your own photos to Canva or use photos from their vast library of free photos in “Elements.”

HACK 4: Use videos to label a key data point. For something like the chart shown below, create a line graph using the chart tools (see above). Then type in “speech bubble” in the “Elements” search window. Limit the results to only photos by selecting the “Photos” option below the search window. Drag a speech bubble onto the design (and pointing to the key data point) and, with the speech bubble selected, click on “Edit Image” in the upper left corner of the design area and then use the “Shadows” tool to add a shadow to the speech bubble image. Now drag a video to the design and size it to fit inside the speech bubble. Note that you can upload your own videos to Canva or use videos from their vast library in “Elements.”


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Mock Up Your Dashboards (Easily)

When I’m starting a new dashboard, I usually make some sketches to help me think about what charts to include, how I’m going to lay it out, how the pages are going to relate to each other, etc. The problem is that my sketches aren’t so good. I end up scratching out a lot and then not being able to interpret it later. Recently, I started using Canva whiteboards for my mock-ups. This free tool has a bunch of features that I like:

  • Large virtual “canvases” with the ability to zoom in on particular items or zoom way out to see the whole thing.

  • Various whiteboard templates which can easily be adapted to data dashboard design or just start with a blank board.

  • Virtual post-it notes, lines, arrows, circles and other elements to annotate the design.

  • Lots of free chart images to use as placeholders.

  • The upload feature which allows you to bring in images of dashboards you might want to riff on.

  • The ability to share and collaborate with others on a design.

Check out this mock-up I created which includes design ideas for various pages of a data dashboard.

CYDI Mock Up by Amelia Kohm World!


Let’s talk about YOUR data!

Got the feeling that you and your colleagues would use your data more effectively if you could see it better? Data Viz for Nonprofits (DVN) can help you get the ball rolling with an interactive data dashboard and beautiful charts, maps, and graphs for your next presentation, report, proposal, or webpage. Through a short-term consultation, we can help you to clarify the questions you want to answer and goals you want to track. DVN then visualizes your data to address those questions and track those goals.


Freedom From Pivoting

60-SECOND DATA TIP_3 (1).png

Often, perhaps most of the time, we do best by looking at our data from a number of different vantage points. Sure, we want the broad view: how are all of our participants doing in the program? But we also want to know how particular types of participants are doing such as those in certain age brackets, those who got a certain set of services, those who persisted in program for longer or shorter periods of time, etc. To see our data broken down into such subgroups can be a pain in programs like Excel*. You have to generate a different pivot table for each type of breakdown. But in programs like Tableau, you can create “parameters” that allow you to toggle among different breakdowns easily and painlessly. With some Tableau know-how, you can see how different types of survey respondents responded to different types of question as in the example below.


***

Data Viz for Nonprofits helps organizations to effectively and beautifully present their data on websites, reports, slide decks, interactive data dashboards and more. Click HERE to learn more about our services and HERE to set up a meeting to discuss how we can meet your particular needs.

*If you have a version of Excel with the “slicer” feature, you can have more flexibility in looking at your data from different angles.

Choose Your Data Visualization Weapon

Tip5.jpg

There are plenty of software programs out there to help you visualize your data. Excel, which you may already have, is perhaps the simplest to use. Other programs such as Tableau and Qlik Sense allow you to create interactive visuals and “drill down” into your data. If, for example, you see an overall downward trend in program participation, you might want to see if the trend holds for subgroups of participants such as women, men, or those in certain age groups. Free versions of Tableau and Qlik Sense are available as long as you store your data and visuals on the companies’ servers (and you can make your data and charts invisible to anyone without the URL).

See other data tips in this series for more information on how to effectively visualize and make good use of your organization's data. 

(This data tip originally appeared on Philanthropy News Digest’s PHILANTOPIC blog.)