Scaling in-cell charts with an Excel formula

 

You can scale   “in-cell charts” by using the following formula:

where:

data_point is the relative reference of   the 1st point in the data_range

data_range is the absolute horizontal   reference of the data

this_cell is the relative reference of   the cell containing the formula

 

Formula is not completely volatile, so   you must press F9 after adjusting column widths.

Scaling is not perfect (zooming affects it) but works OK.

=REPT(“|”,(data_point*100/MAX(data_range))*CELL(“width”,this_cell)/(14+NOW()*0))

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s