Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a Pivot Chart
I am sure there is a pretty simple trick to this that I just cannot figure out. I would like to put these currencies into a pivot table and be able to filter by Country. My ideal situation would be able to set up a Pivot graph that I could pick and choose which currency I wanted to show using the report filter. Everytime I try I cannot get this result. My sheet is set up as the following. Colums have the Country Currency Ticker USD, JPY, GBP, etc with the values beneath them. The rows are labeled by date starting at 1/1/2006 to 10/22/08 starting in cell. The column labels start in B2, the Dates start in A1. how can i turn this into a pivot graph many thanks, dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a pivot table from 4 pivot tables | Excel Worksheet Functions | |||
Disabled "Switch Row/Column" when creating chart from a pivot tabl | Charts and Charting in Excel | |||
Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
Creating a preato from a group of data choosen from a pivot chart | Excel Discussion (Misc queries) | |||
How to create chart from Pivot table but not Pivot chart? | Charts and Charting in Excel |