Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 16th 08, 10:37 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 38
Default Macro to group data in pivot charts

Hi,

I have a pivot chart in excel that is linked to an access database. I would
like the chart to have two series - current month sales and year to date -
but my sales data only has a month column and a year column. Is there any way
to have the year to date series refer only to January in January but then
refer to January, February and March when my March figures come out? I think
that I can somehow do this with a macro but I'm sure how.

Thanks!
Michael

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you group data in a Pivot Table? rhianna New Users to Excel 1 March 28th 07 01:20 AM
Group data in pivot using VBA Nick Excel Programming 2 December 11th 06 05:40 PM
Data Area of Pivot Table and Pivot Charts Missy Charts and Charting in Excel 2 April 13th 06 12:51 AM
Why does the pivot table not allow me to group data? Forrest Excel Discussion (Misc queries) 6 January 13th 06 02:12 AM
Group Pivot data by week cbrah Excel Programming 2 July 24th 05 12:29 PM


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017