ExcelBanter - Plot a scatter chart with categories on the left.

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Plot a scatter chart with categories on the left. (https://www.excelbanter.com/charts-charting-excel/11325-plot-scatter-chart-categories-left.html)

HAF32

Plot a scatter chart with categories on the left.

I want to turn a scatter chart on its head. having the categories listed on
the left and values at the bottom.

How can I do this?

Andy Pope

Hi,

Here are a couple of explanations,

Stephen Bullen's FunChrt2 example.
http://www.oaltd.co.uk/DLCount/DLCou...e=FunChrt2.zip

and Jon Peltier has an explanation.
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Cheers
Andy

HAF32 wrote:
I want to turn a scatter chart on its head. having the categories listed on
the left and values at the bottom.

How can I do this?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

HAF32

Thanks Andy, that did the trick!

"Andy Pope" wrote:

Hi,

Here are a couple of explanations,

Stephen Bullen's FunChrt2 example.
http://www.oaltd.co.uk/DLCount/DLCou...e=FunChrt2.zip

and Jon Peltier has an explanation.
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Cheers
Andy

HAF32 wrote:
I want to turn a scatter chart on its head. having the categories listed on
the left and values at the bottom.

How can I do this?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 12:09 PM.