Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XY-chart with pivottable?
Hello,
I don't need all the fancy tricks of a pivottable/chart, I just use it to sort my technical data, but sometimes I need to display this data by means of an XY-chart, why is this not foreseen in Excell? I hope Microsoft really improves this! Is there some automated workaround for this? Or do I really have to program it in VBA? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
XY-chart with pivottable?
I sometimes need a chart based on the output of a pivot table which of course grows and shrinks over time as the raw data changes. I set up a few columns to the right of the pivot table and test if the relevant cell in each row is empty (then ignore) or contains grand total (then ignore) otherwise return the value in the cell. Plot chart as normal. You do get the blank cell from a fomula plotting as zero on the chart problem though. -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=532175 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date gaps in chart after pivotTable | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel |