Thread: melting of two and more columns

Hi,
I have an Excel chart with several columns of different height.
Is there a way to combine these columns to ONE column which represents their average height/value?

Thx for any help,
Jurgen

Can you be more specific about the data that you have?

"juergenkemeter"
<juergenkemeter.1s6pac_1121385949.7358@excelforum-nospam.com> wrote in
message news:juergenkemeter.1s6pac_1121385949.7358@excelforum-nospam.com...
>
> Hi,
> I have an Excel chart with several columns of different height.
> Is there a way to combine these columns to ONE column which represents
> their average height/value?
>
> Thx for any help,
> Jurgen
>
>
> --
> juergenkemeter
> ------------------------------------------------------------------------
> juergenkemeter's Profile:
> http://www.excelforum.com/member.php...o&userid=25248
> View this thread: http://www.excelforum.com/showthread...hreadid=387375
>

Can you calculate the average in the worksheet and plot that value?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


juergenkemeter wrote:

> Hi,
> I have an Excel chart with several columns of different height.
> Is there a way to combine these columns to ONE column which represents
> their average height/value?
>
> Thx for any help,
> Jurgen
>
>

Hi,
that works fine. But then I have another problem: I have to draw the STDEV of these values into this one column...
Jürgen

How are you planning to draw this?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

juergenkemeter wrote:

> Hi,
> that works fine. But then I have another problem: I have to draw the
> STDEV of these values into this one column...
> Jürgen
>
>