Bar Chart Percentage Graph with Dollar Labels

  • Thread starter Thread starter TKrepitch
  • Start date Start date
T

TKrepitch

Hello. I am trying to replicate a graph that someone else made and I
can't find a way to do it. It is basically a simple bar graph, but
with a trick.

In Year 1, I have $459. 15% of the $459 is product x and the other
85% is product y. The graph is two stacked columns (one with 15%, the
other with 85%),but the label is $459. As the years progress, the
dollar number changes. The left axis measures dollars, so that the
shape of the graph depends on dollar volume.

I just need to figure out a way to create a simple bar graph, but
divide each bar into the component percentages. I'd appreciate any
advice. Thanks!

Sincerely,
Tom
 
Hi Tom -

A stacked column chart (top middle subtype under column type) will use a
Y axis with dollar units, while a 100% stacked column (top right
subtype) will use a percentage for the Y axis, and each stack will total
to 100%, regardless of the total of each stack's values.

- Jon
 
Hi Tom,

Perhaps the trick is to use a clustered column chart and set the Overlap
to 100. Select a data series and from the format dialog choose Options
adjust the Overlap to 100.

Not sure how your data is currently structured by here is an example I used.
Y Cost X Cost X Percentage
A2=Year1 B2=$459.00 C2=D2*(B2/100) D2=15

create a chart based on A2:C2
Hello. I am trying to replicate a graph that someone else made and I
can't find a way to do it. It is basically a simple bar graph, but
with a trick.

In Year 1, I have $459. 15% of the $459 is product x and the other
85% is product y. The graph is two stacked columns (one with 15%, the
other with 85%),but the label is $459. As the years progress, the
dollar number changes. The left axis measures dollars, so that the
shape of the graph depends on dollar volume.

I just need to figure out a way to create a simple bar graph, but
divide each bar into the component percentages. I'd appreciate any
advice. Thanks!

Sincerely,
Tom
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top