Charting with 4 colums in Excel 2007

[ondrocks]

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

[davegugg]

Maybe you should request a moderator move this Excel Charting question to the Excel Charting forum.

Thank You!

[Andy Pope]

not really sure what it is you want to chart but for sure pivot table and chart are the way forward.