Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing Graph Title W/ Pivot
If I have 3 items I am showing on a pivot chart: cost of pears, cost of
peaches, and cost of apples, can I make the title of the graph change if I just want to select a specific element . For instance when everything is select the title for the graph is "Cost of Fruit". What I want is if I only want to show apples I want the chart title to read "Cost of Apples". Any way to do this? Thanks in advance! |
#2
|
|||
|
|||
Select a cell on the worksheet.
Enter a formula that refers to the pivot page cell, e.g.: ="Cost of " & IF(B1="(All)","Fruit",B1) Select the Pivot Chart Type an equal sign (you'll see it appear in the formula bar) Click on the cell that contains the formula Press the Enter key Move the text box to the position you want it, and format it. Jenn wrote: If I have 3 items I am showing on a pivot chart: cost of pears, cost of peaches, and cost of apples, can I make the title of the graph change if I just want to select a specific element . For instance when everything is select the title for the graph is "Cost of Fruit". What I want is if I only want to show apples I want the chart title to read "Cost of Apples". Any way to do this? Thanks in advance! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Chart Title? | Charts and Charting in Excel | |||
Pivot and changing External data source | Excel Discussion (Misc queries) | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel |