+ Reply to Thread
Results 1 to 3 of 3

Pivot Chart Issue

  1. #1
    Forum Contributor Bob@Sun's Avatar
    Join Date
    09-03-2009
    Location
    Montuak, Usa
    MS-Off Ver
    Excel 2007
    Posts
    438

    Pivot Chart Issue

    Hi,

    I need help with my pivot chart.

    Attached you can see that on Item 1, Item 2 and Item 5 I have drawn Lines that are setting minimum Values for each Item.

    Can this be set to appear automatically?
    Attached Files Attached Files
    Last edited by Bob@Sun; 04-11-2010 at 04:25 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Pivot Chart Issue

    I don't think so.

    You may have to consider creating normal charts based on the pivot table rather than using a pivot chart. Of course this will require some VBA.

    http://pubs.logicalexpressions.com/P...cle.asp?ID=553
    http://peltiertech.com/WordPress/reg...-pivot-tables/
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor Bob@Sun's Avatar
    Join Date
    09-03-2009
    Location
    Montuak, Usa
    MS-Off Ver
    Excel 2007
    Posts
    438

    Re: Pivot Chart Issue

    Ok, thanks Andy

+ 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