chartsdata visualizationmicrosoft exceltimeline
Is it possible to place the labels not on the Y axis, but on the data point itself in a stacked bar chart in excel?
I am trying to modify the timeline template available here so that my labels for each bar appear over or next to the bar rather than all the way on the left side.
See the image below for how it looks now.
The only way I've found to accomplish this is to use stacked bar charts where the blank time in between actual events is a series that is set to a blank fill. This method also requires helper columns to assist in feeding the data that the stacked bar chart expects. This method would need a table with as many rows as Y values. This makes it tough since the requirement about new line for every row seems to indicate you want to leave your data in the format it currently uses.
Other thoughts: Have you considered perhaps a charting component to the c# program instead of trying to force Excel to make the graph? Microsoft's Chart Control is a clone of Dundas and is free.
For Excel to create a Stacked Column Chart, you'll need to separate the items you want "stacked" into separate series so Excel will know what to do with them. Here's a quick way to accomplish that:
Here's what it looks like with Excel defaults:
Best Answer
In playing with Excel, it looks like you can right-click on the dataset and select "Add Data Label." I'm not sure how to replicate what you have exactly.