HI,
I have a data and want to present in better format..I am looking for ideas how we can present it.
Can any one please look at it and gives ideas how we can do it,, may be with slicers?
Data file attached
Thanks for advance.
HI,
I have a data and want to present in better format..I am looking for ideas how we can present it.
Can any one please look at it and gives ideas how we can do it,, may be with slicers?
Data file attached
Thanks for advance.
Some thoughts
Your data was not very PT-friendly since each month is in a separate column
I added my macro to make that sort of data into list with Month as a single column, and a function to make PT Page field values into a chart title
It's much easier to make a PT that way
Added an example chart
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Thanks Paul..it gives my idea now....