Bar Chart Right to Left Side

Data

Image

Bar Chart

Image

Add one more data column before the given data

with formula =MAX($C$21:$C$29)+20-C21 (drag down), assuming data in C21:C29

20 is any relatively small number you like

Image

Goto

Insert -> Chart -> bar -> 100% stacked bar chart

Image

use color-> no fill to make blue bar invisible

select y-axis(1,2,3……)  press  ctrl+1

in axis option -> axis label select high

add data labels to red bars

format chart area as you like

( remove x-axis, legend)

Image

there you are….

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