I am in middle of creating a report for my company to project database growth on weekely basis so that at end of every quater we can analyse the total growth. I need some help to create the chart , a bar chart will be good which can project the growth report from the following table
The worksheet looks like this. All 4 colums are important to be shown in the chart
server db_name size date
abc db1 200 Aug 10
abc db2 500 Aug 10
abc db3 600 Aug 10
xyz db4 100 Aug 10
xyz db5 200 Aug 10
xyz db6 350 Aug 10
bdf db7 210 Aug 10
bdf db8 220 Aug 10
bdf db9 300 Aug 10
abc db1 201 Aug 16
abc db2 502 Aug 16
abc db3 603 Aug 16
xyz db4 101 Aug 16
xyz db5 200 Aug 16
xyz db6 352 Aug 16
bdf db7 211 Aug 16
bdf db8 221 Aug 16
bdf db9 302 Aug 16
abc db1 203 Aug 22
abc db2 520 Aug 22
abc db3 610 Aug 22
xyz db4 105 Aug 22
xyz db5 205 Aug 22
xyz db6 350 Aug 22
bdf db7 212 Aug 22
bdf db8 222 Aug 22
bdf db9 305 Aug 22
Maybe you should request a moderator move this Excel Charting question to the Excel Charting forum.
Thank You!
Last edited by davegugg; 09-02-2011 at 10:18 AM.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
not really sure what it is you want to chart but for sure pivot table and chart are the way forward.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks