+ Reply to Thread
Results 1 to 3 of 3

large value range

  1. #1
    Registered User
    Join Date
    Hull, England
    MS-Off Ver

    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


  2. #2
    Forum Guru
    Join Date
    North America
    MS-Off Ver
    2002/XP and 2007

    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
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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