Battery Chart in Excel: Build a Clear Charge Gauge

Yes—Excel can show a battery’s charge as a simple gauge using a 100% stacked bar chart. Enter the charge as a percentage, calculate the unfilled portion, then format the two series so the bar looks like a battery; use a line chart instead when you want to track charge over time.

What a battery chart shows

A battery chart is a visual display of charge level, capacity, or battery performance. Excel does not have a dedicated built-in battery-chart type, but its standard charts and shapes can represent the same information. The best design depends on what the numbers mean:

Current charge: a single horizontal gauge, such as 68% charged, is easy to read at a glance.
Several batteries: a bar for each device makes charge levels easy to compare.
Charge over time: a line chart shows whether a battery is charging, discharging, or holding steady.
Measured capacity or health: a chart can compare current capacity with a baseline, provided the measurements use consistent units.

A gauge is a compact status display, not a diagnostic test. It can show a percentage supplied by a device, monitoring system, or manual record, but it cannot determine a battery’s actual health from that percentage alone. Capacity, temperature, age, load, and the measurement method all affect what a charge reading means.

Set up the charge data

For a one-battery gauge, make a small table with a label, the charge percentage, and the remaining percentage. In Excel for Microsoft 365 on Windows, enter the headings Battery, Charge, and Remaining in A1:C1. Enter a label in A2 and a percentage in B2. Type the value as a percentage, such as 68%, rather than the whole number 68, and format B2 as Percentage if needed.

With the charge percentage in B2, enter this formula in C2 to calculate the portion that is not charged: =1-B2. For an input of 68%, C2 returns 32% (stored as 0.32). The two values add to 100%, which is what the stacked chart needs. This example assumes the entered percentage is between 0% and 100%.

If values come from a form or imported data, it is sensible to validate the input. Select B2, choose Data > Data Validation, and set Allow to Decimal, Data to between, Minimum to 0, and Maximum to 1. This works when the cell stores percentages as decimal fractions: 68% is stored as 0.68. A percentage format changes how a value displays; it does not change the underlying value.

Build a single battery gauge

Select A1:A2, then hold Ctrl and select B1:C2. This selects the battery label and the two chart series, even though the selections are separated. On Mac, use Command in place of Ctrl.
Choose Insert > Insert Column or Bar Chart > 2-D Stacked Bar. If Excel places the series and category in the wrong orientation, select the chart and choose Chart Design > Switch Row/Column.
Click a bar segment to select its data series. Use Chart Design > Add Chart Element > Data Labels if you want values displayed. For a clean gauge, you may prefer to remove labels and put the percentage in a nearby worksheet cell.
Remove unnecessary chart furniture. Select the chart title, legend, or gridlines and press Delete, or use Chart Design > Add Chart Element to turn off the relevant element. Keep the category label if it identifies which battery the gauge represents.

Because Charge and Remaining total 100%, a 100% stacked bar is also a suitable choice. It normalizes each category to the same full length, which is useful when comparing multiple batteries. For one gauge, a regular stacked bar is also fine because its two values already total 100%. The important part is that both portions appear in one horizontal bar.

Format the chart to look like a battery

Click the chart’s filled portion, right-click, and choose Format Data Series. Set Series Overlap to 100% if the setting is available for the selected chart; the stacked-bar type normally places the series end to end already. Adjust Gap Width to make the bar thicker or thinner. A smaller gap makes a single bar look more substantial. Under Fill, give Charge a strong color and Remaining a pale gray or another muted color. Choose colors with sufficient contrast so the filled amount remains obvious.

To add a battery terminal, select Insert > Shapes and draw a small rectangle at the right end of the bar. Format its fill to match the battery outline or use a contrasting neutral color. This shape is decorative: it is not part of the chart data and may need repositioning if the chart is resized. For a simpler, more robust design, use a colored bar with a clear percentage label and skip the terminal.

Use the chart’s axes thoughtfully. A horizontal value axis can help readers interpret the level, but a 0-to-100 scale is usually unnecessary for a small dashboard gauge. If you remove the axis, keep a visible percentage elsewhere so the chart does not imply more precision than the underlying reading supports. Excel’s chart formatting panels can vary slightly by update; right-clicking the chart element and choosing its Format option is a reliable way to open its settings.

Show several batteries or devices

For a comparison chart, put a device name in each row and provide its charge and remainder. For example, rows might list a laptop at 68%, a tablet at 42%, and a spare battery at 91%. Copy the remainder formula down alongside the data, then select the full table and insert a 2-D Stacked Bar chart. Each category becomes a separate bar, making it easier to spot the lowest charge.

Before comparing devices, check that each percentage has the same meaning. A displayed charge percentage is not necessarily a comparable measure of remaining operating time: a laptop under heavy load may run down faster than another device at the same displayed level. Avoid implying that a 50% reading means exactly half the runtime remains unless that relationship has been established for the specific equipment and conditions.

Order the data to suit the reader. You can sort the worksheet by the charge column, or leave devices in a familiar order such as location or equipment type. Use a descriptive chart title and category labels rather than relying only on color. If a chart is used in a report, include a date or time for the readings, because battery status can change quickly.

Chart battery charge over time

A single gauge answers “How charged is it now?” A time-series chart answers “How has the charge changed?” Put timestamps in one column and charge percentages in the next, with one observation per row. Select the two columns and choose Insert > Insert Line or Area Chart > Line. Use a line chart when the sequence and direction of change matter; use markers if readings are widely spaced or there are only a few observations.

Keep timestamps in true Excel date-and-time values, not text that merely looks like a date. If the readings are irregularly spaced, a scatter chart with lines can represent the time intervals more faithfully than a line chart that treats each category as equally spaced. Choose Insert > Insert Scatter (X, Y) or Bubble Chart, then select a scatter option with lines. Format the horizontal axis as a date or time if necessary.

Label the vertical axis as charge (%) and use a sensible scale. A 0% to 100% range is clear when the entire battery range is relevant. A narrower scale can make small changes easier to see, but it can also exaggerate variation; state the scale clearly and do not start the axis at an arbitrary value without a reason. If readings come from different monitoring intervals, note that gaps in the record do not mean the charge stayed constant.

Make the gauge update automatically

When the charge value in B2 changes, the chart updates because it is linked to worksheet cells. The same is true for a multi-battery chart when values are edited within the chart’s source range. If you add more devices below the original range and they do not appear, expand the chart’s data source: select the chart, choose Chart Design > Select Data, and update the Chart data range. Converting the source into an Excel table can make ranges easier to maintain as rows are added: select the data and choose Insert > Table.

For a dashboard, place the gauge near the related device name and show a timestamp for the latest update. A chart based on a manually typed value will not refresh itself from the physical battery. To automate data collection, the source system must provide data to Excel through an appropriate connection, import, or process. A chart only visualizes the values in its source cells.

On Excel for the web, basic stacked bar and line charts can be created and edited, though some detailed formatting controls may differ from the Windows desktop ribbon. Excel for Mac has the same general chart approach; use Command rather than Ctrl for multi-selecting separate worksheet ranges. Menu labels and formatting panes can vary by platform and update, so if a particular control is not visible, select the chart series and inspect its formatting pane.

Common problems and practical fixes

The bar is all one color: check that Charge and Remaining are separate numeric columns and that the chart type is stacked, not clustered. Confirm that both series are included in Chart Design > Select Data.
The remainder is negative or over 100%: check whether the source is entered as 68% or as the number 68. For a percentage-formatted cell, 68% is stored as 0.68. Validate imported values before applying a remainder calculation.
The chart shows 6,800%: a value of 68 was probably formatted as a percentage. Replace it with 68% or 0.68, depending on how the value was entered.
The labels or categories are reversed: use Chart Design > Switch Row/Column, or inspect the ranges under Chart Design > Select Data.
The battery shape drifts when resized: the terminal rectangle is a separate drawing object, not a chart series. Align it again, group objects where appropriate, or use a plain bar without a terminal.
The gauge appears to show a precise runtime: a percentage chart displays the supplied percentage only. It does not calculate remaining minutes or battery health unless you have suitable measurements and a separate, justified model.

Choosing a chart type and interpreting results

Use a stacked bar for a compact charge gauge, especially when the remaining portion should visibly complete a fixed 100% length. Use separate bars when comparing several batteries, and a line or scatter chart when time is the horizontal dimension. A pie or doughnut chart can show two parts of a whole, but it is usually less convenient for reading an exact level or comparing multiple devices. A simple bar is often the clearest option.

Also distinguish charge from capacity. Charge is the current state, commonly expressed as a percentage of the battery’s estimated available capacity. Capacity or battery health concerns how much energy the battery can store relative to a reference or its earlier condition. A chart labeled “charge” should not be interpreted as a battery-health chart. If recording health, document the metric, unit, source, and measurement date so readers know what the values represent.

Battery readings can fluctuate because of measurement estimates, temperature, workload, or recalibration. Small changes do not always indicate a meaningful change in usable energy. For a trend chart, preserve the original observations and avoid smoothing or filtering unless the method is clearly explained. A transparent chart is more useful than a visually polished one that hides how the data was collected.

Frequently Asked Questions

Does Excel have a built-in battery chart?
No dedicated battery chart type is included. A stacked bar chart, formatted with charged and remaining portions, makes a practical gauge; a line or scatter chart is more appropriate for readings over time.

How do I show battery percentage in an Excel chart?
Enter the charge as a percentage in a worksheet cell, create a chart from that value or from charge and remainder columns, and add a data label or display the percentage in a nearby cell. Ensure the source value is stored correctly: 68% is 0.68, not 68.

How do I make an Excel battery chart change when the value changes?
Build the chart from worksheet cells, then edit the charge value in the source cell. The chart updates from those linked cells. It will not read the physical battery automatically unless a separate data-collection connection supplies the readings.

Should I use a bar chart or a line chart for battery data?
Use a bar for a current level or for comparing several devices. Use a line chart for readings recorded over time. If time intervals are uneven, a scatter chart can show the spacing more accurately.

Can an Excel battery chart tell me how long the battery will last?
Not by itself. A charge percentage is not a runtime estimate. Runtime depends on the device, battery condition, workload, and other factors; a chart can display a runtime estimate only if a separate source or well-supported calculation provides one.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.