Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 05, 09:59 AM
HAF32
 
Posts: n/a
Default 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   Report Post  
Old February 3rd 05, 10:34 AM
Andy Pope
 
Posts: n/a
Default

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   Report Post  
Old February 3rd 05, 10:43 AM
HAF32
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting custom chart causes plot area to collapse Chiara Charts and Charting in Excel 0 January 20th 05 06:32 PM
Strange Problem with Chart and Plot Visible Cells Option Marcus Leon Charts and Charting in Excel 1 January 7th 05 04:52 AM
BUG?: Excel scatter chart: will not plot x-values Bob Excel Discussion (Misc queries) 2 December 31st 04 01:19 AM
Fill area beneath a scatter plot JZip Charts and Charting in Excel 4 December 8th 04 02:59 PM
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 2 November 29th 04 09:22 PM


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017