'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Adjust Bar and Column Sizes in Excel Charts for PowerPoint
Question details
The user needs to make small percentage values more visible in Excel bar or column charts embedded in PowerPoint without significantly increasing the overall chart size.
- Product
- Excel, PowerPoint
- Device & OS
- not provided
- Scenario
- Presenting or creating charts where data points contain small percentage values that are visually compressed and hard to read.
- Observed behavior
- Small percentage values on bars or columns are difficult to see because the default vertical axis scale compresses them, making data labels and bars appear too small relative to the chart area.
Click on the embedded chart in your PowerPoint slide to ensure you can access the 'Chart Design' and 'Format' tabs, which confirms the chart is actively linked or embedded correctly and ready for editing.
Adjust the Vertical Axis Scale
Reduce the maximum value of the vertical axis to make the columns appear proportionately taller and easier to read.
By default, percentage charts may scale up to 100% (1.0). If your largest data point is only 60% or 70%, the top portion of your chart is essentially empty space. Lowering the maximum bound expands the bars to fill that space.
Click on the Excel chart embedded in your PowerPoint slide, right-click the vertical (Y) axis, and select 'Format Axis' from the context menu.
In the Format Axis pane on the right, locate the 'Bounds' section under Axis Options.
Change the 'Maximum' bound from 1.0 (100%) to a value closer to your highest data point, such as 0.7 (70%), and press Enter.
Reposition and Format Data Labels
Move data labels outside the columns and use contrasting colors to prevent text from blending into the bars.
Increase Chart Height Proportionally
Slightly increase the vertical size of the chart area to give bars more physical room to stretch without widening the entire chart.
Customize Embedded Charts with WPS Presentation
WPS Office offers a powerful, free solution for creating and editing charts. You can effortlessly adjust axis scales, reposition data labels, and manage embedded spreadsheet data directly within your slides to make small percentage values stand out.
- 1. Open Your Slide: Open your presentation file in WPS Presentation.
- 2. Activate Chart Editor: Double-click the embedded chart to activate the chart editing tools.
- 3. Format Axis: Right-click the vertical axis, select 'Format Axis', and adjust the maximum scale value in the right pane.
- 4. Adjust Labels: Right-click the data labels to modify their positions to 'Outside End' and customize their colors for better contrast.
Frequently Asked Questions
Why do my Excel chart columns look tiny in PowerPoint?
If your data contains small percentage values but your vertical axis is set to a maximum bound of 100% (1.0), the smaller values will be visually compressed. Adjusting the maximum axis bound to closely match your highest data point will make the columns taller and more legible.
Can I edit the Excel chart data directly in PowerPoint?
Yes, if the chart is properly embedded, you can right-click the chart in PowerPoint and select 'Edit Data'. This will open a linked spreadsheet window directly within your presentation where you can update values without opening a separate Excel instance.
How do I prevent data labels from overlapping with small columns?
You can prevent overlapping by changing the default label position. Right-click the data labels, select 'Format Data Labels', and under Label Options, choose 'Outside End'. This places the text above the columns rather than inside them.
