Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Graph help please

  • 16-08-2010 7: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 Posts: 3,498 ✭✭✭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,150 ✭✭✭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