Very creative chart

[sa02000]

I would like to combine scatter chart with bar graph. See in attached excel file. For this dummy data, I would like to show the scatter chart as shown but for each point on scartter graph I would like to show stacked column chart based on the data right below the first data. This is only a very small subset of data large data set that I have. So any way to create these graphs quickly once and then quickly copying to other datasets by changing souce data only will be greatly appreciated.

Thank you and look forward to solutions.

Jay

[sa02000]

Just one clarification, for stacked chart for each dot on scatter graph, I would like to show it as percentage breakdown (how much is coming from which category) and the center of that stacked column should be at the scatter dot itself (so that its actually can be visually seen).

Jay

[Andy Pope]

In future please use meaningful title when posting.

The problem is creating a stacked column with the non categorical data for the X axis.

If you a time series axis instead the stacks will be so skinny such that the stacks are not readable.

Do the columns have to be proportionally spaced according to the values in row 3?

[sa02000]

Andy,
I will put meaningful title in future.

To answer your question yes, stacked chart has to be proportional to values in row3. And I guess that is the biggest challenge to have x-axis based in row 3 instead of just categories. Once I have that I don't really need a scatter chart, I can just use the stacked column chart only.

Thank you,
Jay

[Andy Pope]

I don't see how this is going to be possible then.

You can create the illusion of the columns being proportionally spaced by adding columns with no data. But then the space allowed for showing the stack becomes too small and nothing usefull can be read from the chart.

I think you may need to reconsider what exactly you want from the chart from the readers perspective.