| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
| Setting custom chart causes plot area to collapse | Charts and Charting in Excel | |||
| Strange Problem with Chart and Plot Visible Cells Option | Charts and Charting in Excel | |||
| BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) | |||
| Fill area beneath a scatter plot | Charts and Charting in Excel | |||
Linear Mode
