Automate dynamic Charts from Macro Web Query

S

Sunil_Modi

Hello all Excel users-

I am a bit new to the list and cannot find a solution online as of yet
I am doing a web query to bring in information and then running a sor
on the information. I want to take the data (static columns wit
Dynamic rows) and plot the information in stacked 3D column graph.

The data is CPU-Utilization breakdown by percent ranges across multipl
servers:
Servename Month 0%-9% 10%-19% 20%-29%.....100%
Server 1 January .33 .19 .46 0

Now I can't figure a way to accomodate for additional servers on th
chart when it gets added. How do I get a macro to recognize additiona
Servers when they are popped on through a web Query?

Thank you very much in advance for your help.

-suni
 
Top