You have a bar chart in PowerPoint and need to change it to a line chart. Manually rebuilding the chart from scratch wastes time and risks losing custom formatting such as colors, data labels, and axis adjustments. PowerPoint provides a built-in chart type converter that preserves most of your formatting work. This article explains how to switch a bar chart to a line chart in a few clicks without losing your custom styles.
Key Takeaways: Changing Chart Type Without Losing Formatting
- Chart Design > Change Chart Type: Switches the chart type while keeping data, colors, labels, and axis settings intact.
- Right-click on chart > Change Chart Type: Provides the same functionality from the context menu for faster access.
- Format Data Series > Series Options: Adjusts line thickness, marker style, and smoothing after conversion to match your presentation design.
Why Changing Chart Type in PowerPoint Preserves Formatting
PowerPoint stores chart data and formatting as separate layers. The Chart Data layer contains the numbers and category labels you entered in the Excel-like spreadsheet. The Formatting layer holds colors, font settings, axis scales, gridlines, data labels, and legend positions. When you use the built-in chart type conversion tool, PowerPoint rebuilds only the visual representation of the data series while reapplying the existing formatting rules to the new chart type.
This works because the conversion maps each data series from one chart type to another based on the same underlying data. For example, a bar series becomes a line series, but the fill color of the original bars becomes the line color. Data labels move from the top of bars to the end of line markers. Axis minimum and maximum values remain unchanged. The only properties that reset are those specific to the original chart type, such as bar gap width or bar overlap.
The feature works with all standard chart types in PowerPoint: column, bar, line, pie, doughnut, area, scatter, and stock charts. It does not work with combination charts that mix multiple chart types in one chart. For combination charts, you must convert each series individually.
Steps to Convert a Bar Chart to a Line Chart in PowerPoint
Follow these steps to change an existing bar chart into a line chart. The process works identically in PowerPoint 2019, PowerPoint 2021, and PowerPoint for Microsoft 365.
- Select the bar chart on your slide
Click once on the chart to select it. You will see the Chart Tools contextual tabs appear on the ribbon: Chart Design and Format. - Open the Change Chart Type dialog
On the Chart Design tab, click Change Chart Type in the Type group. Alternatively, right-click the chart and choose Change Chart Type from the context menu. - Select the line chart subtype
In the Change Chart Type dialog, click Line in the left pane. Choose a line chart subtype from the right pane. The most common options are Line, Line with Markers, and Stacked Line. Click Line with Markers if you want data points clearly visible. - Confirm the conversion
Click OK. PowerPoint immediately converts the chart. Your original bar chart now appears as a line chart. The data labels, axis titles, legend, and chart title remain exactly as you set them. - Adjust line formatting if needed
Right-click the line and choose Format Data Series. In the Format Data Series pane, adjust line width, dash type, marker style, and smoothing. For a clean look, set line width to 2.25 pt and enable Smoothed line under Line Style.
Common Issues After Converting From Bar to Line
Data labels appear in the wrong position
After conversion, data labels may overlap or appear too close to the line. Right-click a data label and choose Format Data Labels. Under Label Options, set Label Position to Above for a single series or Center for multiple overlapping series. You can also drag individual labels to a new position.
Line colors do not match the original bar colors
PowerPoint retains the fill color of the original bars as the line color. If the bar fill was a gradient, the line receives the first gradient stop color. To change the line color, right-click the line, choose Format Data Series, click Fill & Line, and select a solid color from the Color picker.
Gap width or overlap settings are lost
Bar-specific formatting properties such as Gap Width and Series Overlap do not exist in line charts. PowerPoint simply ignores these settings after conversion. You do not need to reset them. The line chart uses its own default marker spacing, which cannot be adjusted in the same way.
Chart converts to a stacked line chart unexpectedly
If your original bar chart was a stacked bar chart, PowerPoint converts it to a stacked line chart by default. To change to a standard line chart, repeat the conversion steps and select Line with Markers instead of Stacked Line with Markers. This resets the stacking behavior.
| Item | Bar Chart | Line Chart |
|---|---|---|
| Data representation | Vertical rectangles showing discrete values | Connected points showing trends over time |
| Best use case | Comparing individual categories | Showing continuous data or trends |
| Formatting preserved after conversion | Colors, data labels, axes, legend, chart title | Same as bar chart except bar-specific properties |
| Marker support | Not applicable | Circle, diamond, square, triangle, plus, star |
| Gap width control | Yes, adjustable in Format Data Series | Not applicable |
After converting a bar chart to a line chart, you can further refine the appearance using the Format tab. Adjust the line smoothness, add drop lines, or apply a gradient line fill. Use the Add Chart Element button on the Chart Design tab to add a trendline or error bars to emphasize data patterns.