Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel Graph help please

  • 16-08-2010 08:13PM
    #1
    Grizz
    Registered Users, Registered Users 2 Posts: 54 ✭✭


    Hi
    Im trying to do an unusual type of graph which would compare values and show the difference at the top .
    I have attached a jpg of the type of thing im looking for but have no clue how to generate it.
    The arrows would also be important to show an increase/decrease in the values.

    Any help would be great thanks


Comments

  • #2
    Lu Tze
    Registered Users, Registered Users 2, Paid Member Posts: 3,523 ✭✭✭Lu Tze


    thats just a stacked bar chart is it not? Not sure if there is one with arrows


  • #3
    Grizz
    Registered Users, Registered Users 2 Posts: 54 ✭✭Grizz


    Lu Tze wrote: »
    thats just a stacked bar chart is it not? Not sure if there is one with arrows

    I can do the stacked bar chart alright, but I cant get it to show the difference between the two figures at the top nor the arrows


  • #4
    komodosp
    Registered Users, Registered Users 2 Posts: 1,657 ✭✭✭komodosp


    Grizz wrote: »
    I can do the stacked bar chart alright, but I cant get it to show the difference between the two figures at the top nor the arrows
    Not sure about the arrows, unless you did a VB Script or something, but regarding the values, could you create a third column with the differences and use that as the labels or something?


  • #5
    homer911
    Registered Users, Registered Users 2 Posts: 5,067 ✭✭✭homer911


    I refer to this site when faced with anything tricky in Excel Charts:

    http://peltiertech.com/Excel/Charts/index.html


  • #6
    Grizz
    Registered Users, Registered Users 2 Posts: 54 ✭✭Grizz


    Thanks all
    I kinda got it working, (kinda proud of it :) ) (I attached another Jpeg) however now I have another problem.
    When I try to print the graph, the printer prints out:
    PCL XL Error
    Subsystem IMAGE
    Error: Missingdata
    Operator: ReadImage
    Position: 594

    (obviously the printer works for other docs)

    Anybody any clue how to fix this?
    thanks again


  • Advertisement
Advertisement