How to Create a Random Chart in Google Sheets

Creating a mock dashboard or testing a new report design often requires one thing: sample data. Instead of spending time inventing numbers, you can use Google Sheets to generate a random dataset and turn it into a chart instantly. This guide will show you exactly how to do that, from using simple formulas to build your data to customizing the final chart for a professional look.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Would You Need a Random Chart?

Before diving into the "how," let's quickly cover the "why." Generating charts from random data isn't just a novelty, it's a practical skill for many scenarios:

• Dashboard Mockups: When designing a new dashboard in Google Sheets or another tool, you need placeholder visuals. Random charts let you fill out the design and get a feel for the layout before plugging in real data.
• Testing Chart Formats: Want to see if a line chart or a bar chart better represents your type of data? A quick random chart is perfect for comparing visualization styles without messing with your original datasets.
• Creating Educational Content: If you're building a presentation or a tutorial (like this one!), you need clean, simple-to-understand example data that gets the point across without revealing sensitive information.
• Learning Data Visualization: Practicing your charting and data presentation skills is easier when you're not worried about the accuracy of the underlying data. It lets you focus purely on the visual elements.

Step 1: Generate Your Random Data

The foundation of any chart is the data. Google Sheets has a couple of handy functions purpose-built for creating random numbers. Let's look at the most useful ones.

Using RANDBETWEEN() for Random Integers

The easiest and most common way to generate sample data for charts is with the RANDBETWEEN() function. It does exactly what its name suggests: it returns a random whole number between two values you specify.

The syntax is simple: =RANDBETWEEN(low, high)

Let’s create a simple dataset for "Monthly Website Visitors."

1. Click on a blank cell, say B2, and type the following formula:

=RANDBETWEEN(5000, 15000)

When you press Enter, this cell will display a random whole number between 5,000 and 15,000. To create a full column of data, just click on the cell with the formula, grab the small blue square (the fill handle) in the bottom-right corner, and drag it down for several rows.

Now you have a column of random numbers. Let's add some labels.

1. In the column to the left (column A), let's add month names. In cell A2, type "January."
2. Google Sheets is smart enough to recognize dates. Grab the fill handle on the "January" cell and drag it down. It will automatically populate the cells with "February," "March," and so on.

You should now have a simple, two-column table - one with months and one with random visitor numbers - perfect for creating a chart.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Using RAND() for Random Decimals

If you need random decimal numbers instead of whole numbers, the RAND() function is your tool. It generates a random decimal between 0 (inclusive) and 1 (exclusive).

The syntax couldn't be simpler: =RAND()

This is great for generating percentages. For example, to create a random conversion rate between 1% and 5%, you can modify the formula. Since RAND() gives a number from 0 to 1, we can adjust the scale.

Let's say you want a number between 0.01 and 0.05. Here’s a slightly more advanced formula to do that:

=RAND()*(0.05-0.01)+0.01

After typing this formula, format the cell as a percentage (Format → Number → Percent), and you'll have a realistic-looking conversion rate. This is useful for building mock datasets with different kinds of metrics.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Important Tip: Make Your Random Data Static

There's one catch with the RAND() and RANDBETWEEN() functions: they are "volatile." This means they recalculate a new random number every time you make a change to your worksheet. Your chart will constantly update, which can be distracting and unhelpful.

Fortunately, the fix is easy. You just need to convert your formulas into static values.

1. Select all the cells containing your random number formulas.
2. Copy the cells (use Ctrl+C or Cmd+C).
3. With the same cells still selected, right-click and choose Paste special > Values only. (Or use the keyboard shortcut Ctrl+Shift+V or Cmd+Shift+V).

The formulas will be replaced by the numbers they last generated. Now your data is locked in, and your chart won’t change unexpectedly.

Step 2: Create a Chart from the Data

Now that you have a stable dataset, creating the chart takes just a few clicks.

Inserting Your Chart

1. Highlight your data. Click and drag your cursor to select both the labels (months) and the random numbers (visitors). Make sure to include the column headers if you have them.
2. Go to the menu and click Insert > Chart.

Google Sheets will automatically analyze your data and create a default chart for you, placing it right on your sheet. It’s pretty good at guessing the right chart type, often suggesting a line chart for time-series data or a column chart for categorical comparisons.

Customizing Your Random Chart

A default chart is good, but a customized one is better, even for a mockup. When you create a chart, the Chart editor pane will appear on the right side of your screen. This is where you can polish your visual.

The editor has two main tabs: Setup and Customize.

Under the Setup Tab:

• Chart type: If Google Sheets guessed wrong, or you just want to experiment, you can choose a different visualization here. Try switching between a column chart, area chart, or line chart to see what works best.
• Data range: This confirms the data being used in your chart. You shouldn't need to change this if you highlighted everything correctly in the first step.
• X-axis and Series: Here you can define what goes on the horizontal axis (your months) and what data series is being plotted (your visitors).

Under the Customize Tab:

This is where you can fine-tune the aesthetics.

• Chart style: Change the background color, the font, or make the chart borders smooth.
• Chart & axis titles: This is a big one. Give your chart a clear title, like "Monthly Website Visitors in H1." You can also title your horizontal and vertical axes for clarity.
• Series: Change the color of your bars or lines. You can add data labels to show the exact numbers on the chart, which is incredibly helpful for readability.
• Legend: Choose where to place the legend (e.g., top, bottom, or right). For a simple chart with only one data series, you might not even need one.
• Gridlines and ticks: To create a cleaner look, you can adjust the spacing or even remove the gridlines altogether.

Take a few minutes to play around with these settings. A well-titled chart with clear labels and a punchy color will look much more professional than the default grey box, even if the data behind it is completely random.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Example Walkthrough: A Random Sales Chart in 60 Seconds

Let's put it all together. Our goal is to create a bar chart showing random "Units Sold" for four different marketing campaigns.

1. Set up columns: In cell A1, type "Campaign." In B1, type "Units Sold."
2. Add labels: In cells A2 through A5, type "Campaign A," "Campaign B," "Campaign C," and "Campaign D."
3. Generate data: In cell B2, enter the formula =RANDBETWEEN(150, 400) and press Enter.
4. Fill the column: Click on B2, then drag the fill handle down to cell B5.
5. Make data static: Select cells B2:B5, copy them (Ctrl+C), then paste as values (Ctrl+Shift+V).
6. Insert the chart: Select all your data (A1:B5) and go to Insert > Chart. Google will likely suggest a column chart.
7. Customize: Change the chart title to "Campaign Performance - Q3" and adjust the bar color to match your company's branding.

And that's it! In about a minute, you have a slick-looking placeholder chart ready for your presentation or dashboard mockup.

Final Thoughts

Creating random charts in Google Sheets is a simple yet powerful technique for anyone who works with data. By combining functions like RANDBETWEEN() with the easy-to-use chart editor, you can build placeholder visuals for dashboards, test different chart types, and create examples for your reports and presentations in just minutes.

While Google Sheets is fantastic for manual chart creation and mockups, we know that building reports from your actual, live business data is often a time-consuming and repetitive process. For that, we built Graphed. You connect your data sources - like Google Analytics, Salesforce, or Shopify - and simply ask for the dashboards and reports you need in plain English. Graphed builds real-time, interactive visuals for you instantly, skipping the spreadsheets and formulas entirely.