I have a report that utilizes a Chart with 2 different Chart Types.
It works great with the exception that each Item that the chart plots
is supposed to have it's own designated color that doesn't change. I
can manually set it, but the items don't always come up. When that
happens one of the other items assumes that color or Chart Type.
I've found the MSOWCVBA.CHM file, but it's not very helpful. Is this
the right file? Is there someone out there that can tell me how to
edit the individual entries in the legend using VBA. I'd very much
appreciated it.
Thanks in Advance
It works great with the exception that each Item that the chart plots
is supposed to have it's own designated color that doesn't change. I
can manually set it, but the items don't always come up. When that
happens one of the other items assumes that color or Chart Type.
I've found the MSOWCVBA.CHM file, but it's not very helpful. Is this
the right file? Is there someone out there that can tell me how to
edit the individual entries in the legend using VBA. I'd very much
appreciated it.
Thanks in Advance