Results 1 to 4 of 4

Combo charts that don't mess your unedited data

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2020
    Location
    Perth, Aus
    MS-Off Ver
    Office 16
    Posts
    2

    Combo charts that don't mess your unedited data

    Hi guys I wonder if you can help?

    I'm not sure if I am messing up here or something screwy is happening. I've asked a few colleagues for their opinions (and lots of web browsing) but so far I haven't gotten to the bottom of it.

    I have a chart with multiple data sets that I want to display in a combo of smooth scatter and area under the smooth scatter. Here is my original chart:

    Original Chart.png

    I'd like to have the area under the orange line filled. When I change my chart type to combination and select 'Area' for that particular dataset, my chart now looks like this:

    Fill Area.png

    Note the blue lines, my other data sets have changed also the orange area is not as smooth as the scatter line, but the x/y axis remain the same (as does the data selection). I also want this red line as an area:

    Fill Area-red.png

    If I do the same procedure the red data set moves on the chart!

    Fill Area-red-move.png

    It's jumped ahead in time. Same dataset used, same axis.

    Am I doing something stupid?
    Last edited by tashka; 04-09-2020 at 04:41 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 2-Axis chart with data table is a mess!!
    By RitaB in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-04-2012, 05:51 AM
  2. multiple charts controlled by one combo box?
    By malibu06 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-19-2011, 06:10 PM
  3. Filtering Chart Data To Clean Up Label Mess
    By johnlennon in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-08-2009, 05:12 PM
  4. [SOLVED] [SOLVED] vlookup & combo box charts
    By phil clifford in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-16-2006, 05:35 AM
  5. Data Range Mess
    By Karen in forum Excel Charting & Pivots
    Replies: 18
    Last Post: 01-14-2006, 10:40 AM
  6. Combo Charts
    By Carol in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-15-2005, 10:30 AM
  7. Combo Boxes in Charts
    By Shirley Munro in forum Excel General
    Replies: 1
    Last Post: 11-02-2005, 09:50 AM
  8. Combo Charts
    By Dmorri254 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-26-2005, 04:06 PM

Tags for this Thread

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