Forum Discussion
Include a value inside a bar-graph
Greetings,
I wonder if this can be done:
date, material, size
1-1-18, iron, 43
2-1-18, iron, 50
4-1-18, sliver, 30
Then i what a bar chart, where we have dates on one axis and size on the other, and the bar is labled with the "material"
1-1-18 [_Iron_________]
2-1-18 [_Iron___________]
4-1-18 [_Silver____]
Thanks OM
Hi Otto,
That could be like this
Select Date as Horizontal axis and Size as series;
Format axis with dates and select Text in Axis options to skip dates without data
Add data labels and format them to take Values form cells
select Size column as the range.
Sample is attached.
5 Replies
Hi Otto,
That could be like this
Select Date as Horizontal axis and Size as series;
Format axis with dates and select Text in Axis options to skip dates without data
Add data labels and format them to take Values form cells
select Size column as the range.
Sample is attached.
- Strange my Excel menus are quite diffrent that yours (beside they are in Danish ;- ), mine is Excel 2016.
But i got it figured out.
Do you know, if you can color the individual bars, so iron is one color, siver something and gold is of cause yellow :-)
Thansk OMHi Otto,
Charts do not support conditional formatting. Possible workaround could be if you add to your table on more column for each material calculated as
=IF([@Material]="iron",[@Size],0)
and add data series to chart for each of such column
Remove data labels for all columns except size, color each of series as you desire and finally format the data series with 100% overlap
Result will be like this
and attached.
- Brillant, thank you !
