Hi everyone. This has bugged me for a while but I never thought to ask until now.
When you have a graph referencing some data close to it, when you click on the chart/graph it will outline the data it's referencing in blue, the series names in green, and the X axis names in purple (for a bar/line graph). This is a very useful function and I end up using it quite a bit.
The problem I'm running into is that sometimes after creating a chart, I will click on it and and it will outline everything in the data that I stated above. Then 5 minutes later I will click on the same chart and it won't outline any of the data and I can't figure out what has triggered this change. Does this happen to anyone else? Is this a bug or am I doing something wrong? Look forward to hearing from everyone.
(Sorry to post this in two forums, I didn't see that there was a forum specifically for graphs)
If you click on a Data Label the colured lines do not show up, but if you click in the chart area or on a column then they do. Is it that do you think?
oldchippy
-------------
![]()
![]()
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Hi Oldchippy, thank you for your reply. The problem I am having is that when I click on the chart area it doesn't outline anything on the data cells. Clicking the individual data sets will outline them (such as a bar on a bar graph) but clicking on the chart area won't outline any of the data cells.
When you click on the chart background do you get a border around the whole chart with 8 black square handles, only when I get that the data is highlighted?
oldchippy
-------------
![]()
![]()
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks