I have a chart with a vertical axis that ranges between 0 and 400%.
I would like to format matt the 100% line and text a different color so it stands out over the other values listed on the axis.
Is there a way to do this?
I have a chart with a vertical axis that ranges between 0 and 400%.
I would like to format matt the 100% line and text a different color so it stands out over the other values listed on the axis.
Is there a way to do this?
I'd suggest adding a new series that is always 100%, and use a "highlighted" color for it. See this always informative page from Andy Pope's site for some technical details that will make it easier for you:
http://www.andypope.info/charts/hiliteaxislabels.htm
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Thanks, I aprreciate the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks