Selasa, 26 Februari 2013

RE: [ExcelVBA] disablle legend for secondary axis

 

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 (2)
Recent Activity:
----------------------------------
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