Results 1 to 11 of 11

Simplify Display of Data in Pivot Chart?

Threaded View

  1. 06-23-2021, 07:54 PM #1
    Nick Saunders
    Nick Saunders is offline
    Registered User
    Join Date
    06-23-2021
    Location
    Oceanside, CA
    MS-Off Ver
    365
    Posts
    10

    Question Simplify Display of Data in Pivot Chart?

    Hi,

    I have recorded temperature data and want to make a line graph of this data with power pivot.

    The issue I'm having is, I want to show a high resolution of the data (say 24 readings per day), but I only want the days to show up in the X axis, not the hours. Having 24 hours squeezed above each day under the axis is quite unsightly.

    The example file attached shows how it's currently set up. Is there a way to somehow hide the time so that only the day shows up?
    Attached Files Attached Files
    Last edited by Nick Saunders; 06-25-2021 at 02:59 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add a ROW with aggregated data to pivot table and display on a chart
    By pfraiegari82 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-13-2018, 04:01 AM
  2. Pivot Chart - Display data in X axis (all) items regardless of count
    By gtp2014 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-22-2014, 11:50 AM
  3. Display months for which there are no data in pivot chart
    By Lindman in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-26-2014, 07:56 AM
  4. [SOLVED] Looking to Simplify Pivot Table and Formulas Used to Create Chart
    By mo4391 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-29-2013, 11:44 PM
  5. Pivot Table to roll up data and display in pivot chart
    By Dawson64 in forum Excel General
    Replies: 3
    Last Post: 09-26-2011, 05:06 PM
  6. Display data labels on stacked bar pivot chart ONLY for values greater than 0
    By YippeeKiYay in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-27-2009, 11:22 AM
  7. Can I display the actual data in the data field of a pivot chart?
    By Tom Pivot! in forum Excel General
    Replies: 1
    Last Post: 01-12-2006, 01:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1