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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top