why do i "sometimes" need to "edit chart object" before "source da

  • Thread starter Flirty and Blonde
  • Start date
F

Flirty and Blonde

More often than not I can right click on a graph and "source data" or modify
the chart title. Sometimes though, I have to right click > "edit chart
object", and then I may right click again to do the editing I want. Why do I
need the extra choice of "edit chart object"... and why am I presented with
that on some graphs but not all? Thank you,
 
L

Luke M

If you have grouped something with your graph (such as a drawn line, text
box, etc) then XL treats the whole group as a picture/object, but it is still
smart enough to realize that rather than ungroup everything to change the
chart data, you may just want to directly edit the "chart object".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top