Thread: [Solved] Adjusting Formula In Chart
View Single Post
 
Old 02-24-2018, 11:17 AM
UnkleBuck UnkleBuck is offline Windows 10 Office 2016
Novice
 
Join Date: Sep 2017
Posts: 24
UnkleBuck is on a distinguished road
Question Adjusting Formula In Chart

I have a formula with a funnel chart. I want to put the following values into series cells 1,2, and 3 respectively so the actual chart reflects the following values: 65%, 48%, and 28%. The problem isn't really a mathematical 1, where if I simply drop a zero, or move a decimal point. The problem is that Powerpoint (for some reason) tells the cell series properties that reflect the size of the bars on the chart to size themselves 100X's SMALLER than the percentage of whatever value I put into the spreadsheet cells. I've uploaded a screenshot to illustrate my issue. I wish I could upload the pptx file, but you only allow a pawltry 500k limit. Hope you can help.

Thanks in Advance
Attached Images
File Type: jpg Screenshot.jpg (80.2 KB, 13 views)
Reply With Quote