Bruce, this works! Your help is greatly appreciated. Thank you very much!
--- In ExcelVBA@yahoogroups.com, "Bruce Johnson" wrote:
>
> Click the legend so all are selected.
>
> Click the text of the legend to remove.
>
> Delete key.
>
>
>
> Don't select the graphic of the series and delete, or you'll delete the
> series. To re-add the legend, delete and re-add the entire series.
>
>
>
> HTH
>
>
>
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
> Of sunnywulf
> Sent: Monday, February 25, 2013 1:09 PM
> To: ExcelVBA@yahoogroups.com
> Subject: [ExcelVBA] disablle legend for secondary axis
>
>
>
>
>
> I have an Excel chart which shows different failure categories on the x
> axis. The primary Y axis shows the failing devices (different color per
> device) as a stacked graph per failure category. The secondary Y axis shows
> the cumulative percentage of the failure categories. The legend shows the
> color codes for the devices, and "Cumulative %" as last legend entry. So,
> the legend looks like this:
>
> [yellow] Device 1
> [red] Device 2
> [blue] Device 3
> [green] Device 4
> [black] Cumulative %
>
> How can I keep the legend for the devices (primary Y axis) only, but disable
> the phrase "Cumulative %" (secondary Y axis).
>
> Regards,
> Wolfram
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar