| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refreshing pivot makes second data series line disappear from chart !!!
extract the data from the pivot table by , say, if output is in column G, =if ( G3="","",if g3="grand total","",g3)) then copy this down a few hundred rows this only pulls data and ignores blanks and the last row which is grand total. now just highlight the data and click on chart wizard and follow it through. -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=551779 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding additional data to a pivot chart | Charts and Charting in Excel | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Threaded Mode
