Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 28th 13, 03:08 PM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2013
Posts: 2
Default Scatter chart with categories on x-Axis

Hello,

I want to make a chart in Excel that plots values on the y-axis to the specific category. The category is plotted on the x-axis. See example he http://www10.pic-upload.de/28.02.13/wuag2tpidf53.jpg

I am almost sure that excel can do that, since it can everything

Thanks a lot for your help

  #2   Report Post  
Old March 1st 13, 04:12 AM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 12
Default

Hi SPi86,

Welcome to the forums.

Of course you can do this

Set up your data like the picture.

Then create a line chart with markers, not an XY chart.

Then Switch the Rows/Columns from the Design Ribbon.

Let me know if this works for you.

Steve=True
Attached Images
 
  #3   Report Post  
Old March 1st 13, 04:17 PM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2013
Posts: 2
Default

Hey,
Thanks for your reply. I can reproduce your diagram, and it is an almost ok solution for my problem

The problem with your solution is that I have to rearrange my data. (I get the data the way I showed it in the picture.) And to rearrange the data I would like to avoid.

Another ok, but not perfect thing about your solution is that I have to change the symbols by hand. I forgot to say that in the beginning, but I would like to have for each category A, B, C a unique symbol. With that I mean over category A is symbol 1, over category B is symbol 2 ...

Do you know how to do that?

Thanks again for your help




Quote:
Originally Posted by Steve=True View Post
Hi SPi86,

Welcome to the forums.

Of course you can do this

Set up your data like the picture.

Then create a line chart with markers, not an XY chart.

Then Switch the Rows/Columns from the Design Ribbon.

Let me know if this works for you.

Steve=True
  #4   Report Post  
Old August 8th 18, 03:21 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2018
Posts: 1
Default Scatter chart with categories on x-Axis

If you numerically code your x axis text categories (e.g. 1,2,3), list them in a single column ensuring you list each code as many times as there are data points for that category, then in adjacent columns list plot points for respective variables against relevant text category code and just leave blank cells against non-relevant text category code, you can scatter plot the final table and get the desired result. Any questions let me know.

On Friday, March 1, 2013 at 1:08:34 AM UTC+11, Spi86 wrote:
Hello,

I want to make a chart in Excel that plots values on the y-axis to the
specific category. The category is plotted on the x-axis. See example
he http://www10.pic-upload.de/28.02.13/wuag2tpidf53.jpg

I am almost sure that excel can do that, since it can everything

Thanks a lot for your help




--
Spi86




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
Add multiple categories to horizontal axis in chart Tango[_2_] Charts and Charting in Excel 1 April 18th 09 08:13 PM
Hiding categories in the category axis of a chart Leo Charts and Charting in Excel 2 February 9th 08 04:28 PM
Column Chart - X axis too thin because of MANY categories. Mike Charts and Charting in Excel 3 June 15th 06 01:18 PM
Sub-Categories for X-axis labels, line on bar chart? cfagan Charts and Charting in Excel 1 March 3rd 06 06:01 PM
Plot a scatter chart with categories on the left. HAF32 Charts and Charting in Excel 2 February 3rd 05 10:43 AM


All times are GMT +1. The time now is 06:14 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017