Excel Guides

Numeric Value and Percentage Value in a Graph Column in Excel

When you want to add both numeric values and percentage values in a graph column in Excel, you need to first add the numeric values. To do this, click on the cell where you want the numeric value to appear and then type in the number. Next, click on the "%" sign next to the cell. This will change the number into a percentage. Now, click on the "=" sign next to the cell and type in the number that you want to be divided by 100. This will give you the percentage value. Finally, click on the "Graph" tab and select "Column."

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.