If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart % difference From
I have used the inbuilt functionality of a pivot chart to look at a specific value and then compare it to the corresponding value for the year before, this gives me results such as 6.5%. My data only goes back as far as 02/03 and so the values for these records are blank, However these records do appear in my chart giving it a strange look as the first 12 month records are blank and the values starts for April 03/04. My question is, is it possible to exclude the null or blank values in my chart, thus giving it a more professional appearence? Thanks -- cereldine ------------------------------------------------------------------------ cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069 View this thread: http://www.excelforum.com/showthread...hreadid=519346 |
#2
|
|||
|
|||
Chart % difference From
1) Replace the nulls by =NA()
or 2) Click chart; use Tools|Options ; open Chart tab; specify how blanks (missing/empty cells) are to be treated. Try to make Subject match the question best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "cereldine" wrote in message ... I have used the inbuilt functionality of a pivot chart to look at a specific value and then compare it to the corresponding value for the year before, this gives me results such as 6.5%. My data only goes back as far as 02/03 and so the values for these records are blank, However these records do appear in my chart giving it a strange look as the first 12 month records are blank and the values starts for April 03/04. My question is, is it possible to exclude the null or blank values in my chart, thus giving it a more professional appearence? Thanks -- cereldine ------------------------------------------------------------------------ cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069 View this thread: http://www.excelforum.com/showthread...hreadid=519346 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Difference between Microsoft Graph and Excel Chart | mrcrouter | General Discussion | 0 | October 14th, 2005 03:49 PM |
pasting chart shows chart area, not the chart | Pirjo | Powerpoint | 3 | October 13th, 2005 04:31 AM |
Urgent Chart Questions | Brent E | General Discussion | 0 | May 9th, 2005 11:01 PM |
Scrollbar on Chart Jumps to Left when Chart is Clicked | Bob | Charts and Charting | 5 | May 1st, 2005 02:06 AM |
build chart template; then add series one by one | L Mehl | Charts and Charting | 2 | February 12th, 2004 10:53 PM |