C
cgkang
Hi. I'd really appreciate any kind of help. I'm trying to make a
stacked column graph with this data:
1st 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
C2360a 8450 8000 2900 750 11800 9800 2900 20750 865 2928 5800 26950
HM HM Skulls Tires w/ Rims P&S HM Turnings HM Lime Dolag Borings
Shred
I am not too sure how to organize this data, for one, to properly do
this. Anyhow, first, I made a stacked column graph (changing series
in rows --> columns) with the first two rows of the data. The problem
that I'm faced with is that, what I would like to do is change the
color of the block according to the type of material it is, which is
the 3rd row (starting with HM). So in this particular set of data, I
would like the four blocks of "HM" to be of the same color. For now,
I'm working with just one set of data, but there is other data, where
HM might be in a different position (not in the 1st, 2nd, 6th, & 8th,
but maybe in the 1st, 2nd, 4th, & 7th) and I might have two blocks of
"Shred" and etc.
(example of another set of data, which I would like on the same plot:
1st 2nd 3rd 4th 5th 6th 7th 8th
C2361a 9300 13000 2800 19200 750 5150 18650 32400
Shred P&S Turnings HM Borings HM Shred)
I guess I'm wondering if there's a way to program a variable to define
it to a cell, which would keep the color of that variable the same
throughout a stacked graph? (if that made any sense, I am not too
familiar with Excel yet)
Please reply with any help or if there is a need for clarification. I
am quite new to more advanced Excel functions, and need help
harnessing the power of Excel!
Any help please!
stacked column graph with this data:
1st 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
C2360a 8450 8000 2900 750 11800 9800 2900 20750 865 2928 5800 26950
HM HM Skulls Tires w/ Rims P&S HM Turnings HM Lime Dolag Borings
Shred
I am not too sure how to organize this data, for one, to properly do
this. Anyhow, first, I made a stacked column graph (changing series
in rows --> columns) with the first two rows of the data. The problem
that I'm faced with is that, what I would like to do is change the
color of the block according to the type of material it is, which is
the 3rd row (starting with HM). So in this particular set of data, I
would like the four blocks of "HM" to be of the same color. For now,
I'm working with just one set of data, but there is other data, where
HM might be in a different position (not in the 1st, 2nd, 6th, & 8th,
but maybe in the 1st, 2nd, 4th, & 7th) and I might have two blocks of
"Shred" and etc.
(example of another set of data, which I would like on the same plot:
1st 2nd 3rd 4th 5th 6th 7th 8th
C2361a 9300 13000 2800 19200 750 5150 18650 32400
Shred P&S Turnings HM Borings HM Shred)
I guess I'm wondering if there's a way to program a variable to define
it to a cell, which would keep the color of that variable the same
throughout a stacked graph? (if that made any sense, I am not too
familiar with Excel yet)
Please reply with any help or if there is a need for clarification. I
am quite new to more advanced Excel functions, and need help
harnessing the power of Excel!
Any help please!