Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 9th, 2004, 06:19 PM
Authorized User
Join Date: Oct 2003
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default Stacking Chart with Rolling Totals and Trend Line

I am using Excel 97. I am trying to create a chart using VBA which will roll the data. For Example: I want to have NIU3 in one stack, NIU4 & C NIU4 in one stack and NIU5 & C NIU5 in the next stack. I want this done on a daily basis with a rolling total.


      03/05 03/06 03/07
NIU3 20 18 20
NIU4 15 13 14
CRG NIU4 15 13 14
NIU5 20 18 18
CRG NIU5 22 20 22
total 92 82 88

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to draw indicator line in owc line chart AlexOo General .NET 0 July 9th, 2007 10:32 PM
line-chart olof1 ASP.NET 2.0 Professional 2 April 8th, 2007 10:07 PM
Please help in creating Line Chart in ASP shinde.chetan Classic ASP Basics 2 February 6th, 2007 07:15 PM
multiple line chart in crystal report ganans BOOK: Professional Crystal Reports for VS.NET 1 September 25th, 2006 12:13 PM
How to plot data from an array in a line chart ! Alseikhan Excel VBA 0 January 27th, 2006 12:22 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.