Karthikeyan Devan
Board Regular
- Joined
- May 5, 2009
- Messages
- 114
I would like to get the process steps to get the dynamic chart. i have the datas in sheet names (data analysis). Here in I have dates from C6:EN6. And the producation datas I have per day starting in C33:EN33. Now when i need help where the chart will automatically update the datas of last 30 days. Everyday the column will get increased. In this case, we need to reduce one colummn from left tand increase once column in right.
Please explain how to do right from the scratch since this is new for me. As a FYI, i am using Excel 2007 / 2010
Any help on this would be greatly appreciated.
Please explain how to do right from the scratch since this is new for me. As a FYI, i am using Excel 2007 / 2010
Any help on this would be greatly appreciated.