Multiple chart creation using multiple series in the same row



Hello every one. I'm hoping to get Jon's or Ed's input here. Hopefully Ed's
as I'm attempting to use his Multiple Chart Creator (MCC) Excel sheet as the
basis for the chart creation that I want.

Essentially my question is this. I want to be able to create multiple
charts simultaenously using a simple command button not unlike Ed's MCC.
Unfortuntately I want a Surface chart (not columns) that utilizes three
seperate series in the same row.

Here's what I want.

Columns A and B have equipment names and S/N's. Columns C and D have
equipment type identifiers. Columns E through M have the data I want
charted. Column N has the average of the data, and columns O through R have
other data that is insignificant to this discussion.

ID SN Loc Type V1 V2 V3 V4 V5 V6 V7 V8 V9 Avg
1 123 xxx xxxx 118 135 118 95 123 79 109 136 91 112
2 132 xxx xxxx 116 106 91 107 106 87 125 101 67 101
3 101 xxx xxxx 108 112 82 105 91 111 107 99 116 103
4 198 xxx xxxx 169 162 199 130 129 164 109 117 151 148
5 225 xxx xxxx 175 168 162 175 176 160 163 176 154 168

There will be three series. There are several hundred rows. I don't need
any axis labels.

Series 1 = V7, V8, V9 (columns K, L, M)
Series 2 = V4, V5, V6 (columns H, I, J)
Series 3 = V1, V2, V3 (columns E, F, G)

If I could get the chart title to be both column A and B that would be
great, but just column A would suffice.

I've tried messing with Ed's MCC to no avail. I'm not that great at VBA
I'll admit, but I just can't figure out how to do this.

Thanks for all your help!


Patrick Molloy

can you achieve the chart manually? If yuo can, then start again after
switching on the macro-recorder...that s the best way to learn.

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