+ Reply to Thread
Results 1 to 3 of 3

large value range

  1. #1
    Registered User
    Join Date
    12-06-2018
    Location
    Hull, England
    MS-Off Ver
    2013
    Posts
    1

    large value range

    I previously seen a column chart that was split so that it could cover two series with a large range of values

    The first series was number of vehicles of a type with a range of values between 5 and 100 the second series was the total cash value of these vehicles with a range of 500k to 5.5m

    Any ideas

    thanks & regards

    Spud1960

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    10,092

    Re: large value range

    I'm thinking either a single column chart where you have one series on the primary axis and the other series on the secondary axis (https://support.office.com/en-us/art...rs=en-US&ad=US ) or a panel chart where each series is plotted in a separate panel against a common category axis (https://peltiertech.com/Excel/Charts/StackedCharts.html ).
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    23,643

    Re: large value range

    Hi and welcome to the forum.

    Perhaps it was a chart that used two y axes with one series plotted on the y1 axis and the other on the y2 axis.

    If you have some specific data you want to chart then upload a workbook and describe whag you want to see and where.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

    Forum Rules Updated September 2018. Please read them by clicking here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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