View Single Post
  #4   Report Post  
Old August 8th 18, 03:21 AM posted to microsoft.public.excel.charting
[email protected] is offline
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:

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

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

Thanks a lot for your help