Results 1 to 4 of 4

My stacked column Bar chart is not showing the right data!

Threaded View

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    Coventry
    MS-Off Ver
    Excel 2007
    Posts
    25

    My stacked column Bar chart is not showing the right data!

    Good morning!

    Right, I'm trying to show a a very basic stacked columm chart showing Targeted Savings vs Actual Savings by Quaterly Year - All this data is bogus for now.

    My actual savings seems to be working nicely - but the targeted savings chart is not showing the figures in my table.

    For example, actual savings were say £150,000 but targeted savings were £300,000 - My graph is showing this as about £440,000 as the target - What the heck is going on there?

    I would also like the Y axis to be fixed at 500K but when changing this via Format Axis - it just totally screws up my graph.

    Please see Spreadsheet attached to thread.

    Any ideas? & Many thanks for reading.

    James
    Attached Files Attached Files

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