+ Reply to Thread
Results 1 to 6 of 6

Scatter plot and Bar chart

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    Helsinki, Finland
    MS-Off Ver
    Excel 2007
    Posts
    11

    Scatter plot and Bar chart

    Hi,

    I would like to use multiple scatter plots and bar charts in one chart. Problem is that X-Axis goes horribly wrong every time, even if I have same points on both scatter and bar. Here is Data for 2 Scatter Plots

    X Scatter1
    1,43 0,14
    2,60 0,25
    3,04 0,37
    3,60 0,50
    3,93 0,60
    4,69 0,80
    X Scatter2
    5,10 0,92
    5,36 1,00
    6,43 1,26
    7,60 1,53
    8,19 1,65
    8,79 1,77
    9,69 1,93

    And here is data for 2 Bar Charts

    X Bar Chart1 Bar Chart2
    1,43 #N/A 0,00
    2,60 #N/A 0,01
    3,04 0,01 0,01
    3,60 #N/A 0,01
    3,93 #N/A 0,01
    4,69 #N/A 0,00
    5,10 0,02 0,01
    5,36 #N/A 0,01
    6,43 #N/A 0,02
    7,60 0,04 0,02
    8,19 #N/A 0,01
    8,79 0,11 0,02
    9,69 #N/A 0,01

    I start with Scatterplot and put those in the graph, then I add other data and change it to Bar Chart, but this is the point where X-Axis gets mixed up and scatter plot X data and Bar chart X data are not matching. Any ideas?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,777

    Re: Scatter plot and Bar chart

    Post a workpost example so we can see what you chart currently looks like when you make it.

    Explain how the scatter should relate to the bars? What exactly are you expecting as a result.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-16-2013
    Location
    Helsinki, Finland
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Scatter plot and Bar chart

    example.xlsx

    Here is simple example. As you can see, barChart and Scatter Chart X values are not matching.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,777

    Re: Scatter plot and Bar chart

    Add secondary horizontal axis, which will allow you to define min/max values.

    The columns are equally spaced but the x values are not. So I don't know how you expect those to align,

    The data in column A is simply a category label for the columns.

  5. #5
    Registered User
    Join Date
    01-16-2013
    Location
    Helsinki, Finland
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Scatter plot and Bar chart

    ok, if possible could you do it to that example? Thanks, otherwise will just start testing myself. I would just hope to find away that it would work out on its own, bc I have 23 more charts to do

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,777

    Re: Scatter plot and Bar chart

    I have added the secondary axis to the chart.

    On sheet2 I have created a chart where the columns are made using error bars on 2 xy-scatter series.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Plot points on a area chart or plot areas on a scatter chart
    By maggy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-17-2012, 04:39 AM
  2. How to plot a scatter chart
    By bouncey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2011, 08:03 AM
  3. Plot 3 sets of data in scatter chart and area chart in one
    By geoffs52 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-24-2009, 04:42 AM
  4. Add names to scatter plot chart
    By oberon.black in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-29-2005, 02:05 PM
  5. [SOLVED] Post-vs- pre plot scatter chart
    By DSR in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-05-2005, 09:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1