How to Make a Chart in Excel for Your Small Business

To make a chart in Excel, organize your data into a clear summary table, select the range, and choose a chart from the Insert tab. Use columns to compare counts, a line to show a trend, or horizontal bars for categories with long names. Before formatting anything, check that the numbers cover the intended periods and that overlapping stages are not being added together.

For a small business, the question might involve inquiries received, proposals sent, or jobs completed. Those measures can help explain the workload, but each needs a consistent definition. A polished chart cannot fix a worksheet where staff count proposals differently or record the same request more than once.

Define the question before choosing a chart

“How many inquiries arrived each month?” is different from “How many of the inquiries received this month led to proposals?” The first counts events by date. The second follows a particular group of inquiries through the process. Mixing the two can produce an apparently precise rate that compares different people and time periods.

Start with one measure. Define a valid inquiry, the date used in the report, and the rule for duplicates. For completed work, decide whether one entry represents a project or an individual deliverable. Write these definitions in a notes sheet so another person can maintain the workbook without guessing what the previous owner meant.

The fictional figures below represent activity recorded in each month. They illustrate how to build a chart; they are not a conversion funnel or evidence about a real business. A proposal sent in March could relate to an inquiry received in February, while a job completed in April might have been approved earlier.

Prepare a table Excel can interpret

Put the headings in the first row and keep each measure in its own column. Enter the months and their counts underneath. Avoid merged cells, blank rows inside the range, and entries such as “about 40” in numeric columns. Keep an estimate or explanation in a separate note rather than mixing text with the values being plotted.

If the source contains individual inquiries rather than monthly totals, prepare the summary first. A list of names and dates does not define the counting rule by itself. For a larger source, Microsoft’s overview of PivotTables and PivotCharts explains tools for summarizing records and exploring the resulting data.

Check the dates before grouping. An entry such as 03/04 can mean March 4 or April 3 depending on the workbook’s regional settings. Use complete, unambiguous dates in the source and an appropriate display format in the report. For multiple years, use both year and month; otherwise, different Januaries can accidentally become one category.

Keep a copy of the original records before cleaning imported information. If an unexpected count appears, you should be able to trace it back to the entries included, rather than trying to reconstruct which rows someone deleted while preparing the report.

Create a clustered column chart

In desktop Excel, select the summary including its headings. Open Insert and choose a Clustered Column chart. You can also start with Recommended Charts. Microsoft’s chart creation guide covers selection and basic editing; the controls vary between desktop and web versions.

Check the horizontal axis and legend after insertion. In this example, months belong on the horizontal axis, while inquiries, proposals, and completed jobs are the three series. If they are reversed, use the chart’s row/column switching control and inspect the result. Do not rely on colors alone to decide whether the interpretation is correct.

Replace a generic title with a description such as “Monthly inquiries, proposals, and completed jobs.” Include the reporting year in the surrounding context. “Business results” would be too broad: this chart contains three activity counts, not revenue, profit, customer satisfaction, or a complete assessment of business performance.

Match the chart type to the comparison

Clustered columns suit the side-by-side monthly counts in the example. A line is useful when the main question concerns the progression of one measure over time, such as weekly inquiries. Horizontal bars can make long service names easier to read when comparing categories rather than dates.

Avoid stacking inquiries, proposals, and completed jobs as if they were exclusive parts of one total. One opportunity can appear at all three stages. Adding those counts would create a total with no clear business meaning. A pie chart is also a poor default for a time series: the fact that you have several numbers does not establish that they form meaningful slices of a whole.

Choose the simplest display that answers the question. If the audience only needs four exact monthly counts, a short table may work better than a complicated combination chart. You can keep the underlying table available even when a chart is useful for a meeting.

Format for reading rather than decoration

Use a small, stable set of colors, one per series. If proposals are blue in one report, preserve that meaning in the next. Changing colors simply to make each presentation look different forces readers to learn the legend again and makes comparisons less dependable.

Inspect the vertical scale. In a column chart, an axis that starts above zero can exaggerate differences in bar height. If a small variation needs attention, explain the scale and consider whether a line or a supporting table communicates it more clearly. Avoid 3D effects that add visual depth without adding information.

Data labels can help with a small example, but become distracting when every point competes with the legend and axis text. Keep the labels that answer the audience’s question. During a meeting, readers should be able to see the pattern and find the exact values without decoding overlapping text.

Check that a new month actually reaches the chart

Add the next period to the summary, then verify that it appears in the chart’s source range. Updating a worksheet does not prove that every chart includes the new row. Inspect the selected data before exporting the report, especially if the original selection was a fixed range.

A structured table or PivotTable can simplify maintenance, but the result still needs checking. Refresh a PivotTable after changing its source and confirm that the source includes the new records. Correct the data or range rather than typing a different number into a presentation to make it look current.

Assign an owner and a reporting cutoff. If one person records inquiries daily and another enters completed jobs only at month-end, a midmonth report can look unbalanced. Mark partial periods clearly. Our Google Forms quote-request guide explains how consistent intake can support the records behind this kind of report.

Separate observations from explanations

In the fictional table, April has more recorded inquiries than March. Proposals and completed jobs also increased, but the chart does not explain why. A campaign, seasonal demand, staffing changes, or a different recording practice could be involved. Investigate the source, service, and period before assigning a cause.

Do not divide April’s 14 completed jobs by its 60 inquiries and label the result a conversion rate. To measure progression for a group, identify the inquiries that entered during a defined period and follow those same records to the chosen outcome. That follow-up can extend beyond the month in which the inquiries arrived.

A useful next question might be, “Which services have proposals still waiting for a response?” The monthly chart highlights an area to investigate; the underlying opportunity list supports action. Keep the visual connected to those records rather than treating it as a substitute for them.

Frequently asked questions

Do I need formulas for a first chart?

Not if you already have a checked summary table. Formulas and PivotTables become useful when you need to calculate or group information from a larger source. Decide the counting rule before choosing how to calculate it.

How can I show just one series?

Select the periods and the desired measure, or adjust the chart’s selected data. Check that the category labels still correspond to the values. Removing a series should not change what the remaining one represents.

Can I use it in a proposal or presentation?

Yes, but check whether you are pasting an image, an embedded object, or linked content. A static image will not update when the workbook changes. A link may depend on access to the original file. Choose deliberately and review the delivered version.

Make the report traceable and maintainable

Define the measure, prepare the summary, choose a clear display, and verify the source whenever it changes. Keep inquiries, proposals, and completed work distinct, and explain the reporting period. Excel can then help the team understand activity without turning simple counts into conclusions the records do not support.