Link
Short Ver.
- Create a separate column for each colored label, and have the output be Zero or #N/A
- Change the plot of these to "Line Chart"
- Click on the label and select "Category Name" uncheck the rest
- Under the labels set the alignment label position to "below"
- Click on the actual lines and hide them
- Change the color of the labels
- Add the legend back if you removed it
- Click on the legend marker for labels "it should still be there even if there is nothing" change the color so it appear son the graph
- Right click on the line, and click "Add Data Labels"
- Now you can edit it just like above, just make sure to make the line no color again afterwards
No comments:
Post a Comment