hi
is it possible to label specific points in a chart? so for example i want to tag week 25 when brexit vote happened can i tag that by selecting week 25 in the chart? or is it a manual process?
thanks
hi
is it possible to label specific points in a chart? so for example i want to tag week 25 when brexit vote happened can i tag that by selecting week 25 in the chart? or is it a manual process?
thanks
Hi bjbboats,
What sort of chart do you mean?
One way of displaying events over a timeline is to use a combination graph where a Line represents the usual metrics & a Bar chart with a subtle colour sits in the background showing that event.
Remember you are unique, like everyone else
Thanks for getting back to me and the suggestion. I'm using a combo chart already and would also need to include other events, not just brexit.
Exactly how do you want to highlight or mark or label these points?
I could see using custom data labels https://support.office.com/en-us/art...9-e8109fdc1613 then follow the link to the "change the look...." help page.
I could also see using a strategy similar to this: http://peltiertech.com/Excel/Charts/FormatMinMax.html
Originally Posted by shg
You can add as many columns as you want with whatever event name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks