+ Reply to Thread
Results 1 to 3 of 3

Pivot Chart Radar Chart Labels Problem

  1. #1
    Registered User
    Join Date
    12-02-2011
    Location
    Coventry, England
    MS-Off Ver
    Excel 2010
    Posts
    47

    Pivot Chart Radar Chart Labels Problem

    I have created a radar pivot chart that will allow the user to change by date values. The pivot chart sorts by a category, HSSM, Performance Training and Equine. I was wondering if I was able to amend the data labels to only read the values, eg;
    Physio A
    Physio B
    Diet A
    Diet B

    instead of ;

    HSSM Physio A
    HSSM Physio B
    HSSM Diet A
    HSSM Diet B

    I need to keep the groupings so they stay together on the Radar Chart but it looks cluttered; I'm not sure what I should be looking at when I research it or if it is at all possible. Perhaps there's a way I can create the radar chart using vba without using a pivot chart from the main data source and still allows the user to pick a date to filter the chart and display the radar chart, changing when the date changes.

    I attach a screen print to explain better. I would be very grateful if I could be pointed in the right directon. Many thanks in advance.
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    01-31-2010
    Location
    London, England
    MS-Off Ver
    Office 365 (2110)
    Posts
    1

    Re: Pivot Chart Radar Chart Labels Problem

    I have exactly the same problem---did you manage to find a solution?

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Pivot Chart Radar Chart Labels Problem

    Hello nicoj. Welcome to the forum.

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

    Additionally as a new member you will not be able to post the link back to this thread as reference. You will have to manually type it in.
    Also since this thread is a little over 3 years old it is unlikely any of the original participants are still monitoring it.

    Again welcome and am looking forward to seeing your new thread.
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Radar Chart - series chart type conversion issues
    By Prince Dakkar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-20-2015, 08:44 AM
  2. Change Pivot radar chart with macro
    By Horatius in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-30-2014, 06:12 AM
  3. Change chart/pivot table numeric labels to associated text labels
    By petschek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 05:32 PM
  4. Pivot Chart Data Labels Help
    By Smiffy3594 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-18-2013, 04:21 AM
  5. circular position radar chart labels
    By hansma in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-13-2010, 05:40 AM
  6. [SOLVED] x-axis labels on a pivot chart
    By tykeinburton in forum Excel General
    Replies: 4
    Last Post: 01-13-2006, 10:10 AM
  7. radar chart & labels
    By uriel78 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-22-2005, 04:06 PM

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