Tag: trendline

Google Sheets: Intermediate Chart Building, workflow

This is Part 3 of this Google Sheets Intermediate Project Course. However, this part of the course can also stand on its own.  If you are looking for part one or two, you can get it here:

Part 1 || Part 2

In this tutorial, we will dive into how to build charts. We’ll look at how we prepared our data for our chart. We’ll then cover some more detailed ground so that we can get our chart just right.

We will create a chart displaying the day change of two USD-XRP currency gateway agencies Bistamp and Gatehub.

The data we will be using to build our chart can be found here:

XRP Google Sheet

Contents

• Recap
• Stage 3: Chart Building
• Preparing the Data For a Chart
  • The Problem with Raw Data
  • Getting Data Ready for a Chart
• Creating the chart
  • Selecting the Range
  • Changing the chart type
  • Horizontal Axis
  • Titles
  • Working with Series Data
  • Finishing Touches
• Conclusion

Back to Top

Continue reading “Google Sheets Intermediate Project: Comparing the Best Daily Currency Exchange Rates Between Two Agencies – XRP/USD Chart Example Part 3”