Recent content by messsp

I'm running a loop through rows and columns in a spreadsheet. the purpose of the loop is to highlight certain cells that fulfill a specific criteria. Now I want to copy and paste into a different spreasheet those columns whose cells are highlighted. If I use .Adress for each highlighted cell I...

In the same graph I would like to merge two different types of column charts: the clustered and the stacked columns. For the first three observations I would like the two series to be displayed as clustered columns but for the last observation I would like to show the two series with their...

I am having troubles in merging two different chart types of Excel into one. More specifically: For each point in time (4 months in total) I have two sets of data (A and B). For Jan, Feb and Mar I want to display A and B as clustured columns (i.e. one column for A and one for B close to each...

Thanks! I thought about it but the problem is that when I re-size the chart area, the object keeps the same size and doesn't adjust to the new dimension. I even tried to group the object with the chart but this doesn't seem possible. This is why I was wondering if a more "stable" solution...

Hi! I'm trying to make transparent the columns of my Excel chart. If you go to Format Data Series/Fill Effect, the transparency option is not available. Any ideas on how to solve this? Thanks