Results 1 to 5 of 5

changing labels of a bar chart to display other data

Threaded View

  1. #1
    Registered User
    Join Date
    08-23-2022
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    66

    changing labels of a bar chart to display other data

    Edit to combine two similar (I think) questions. Workbook small update.

    Trying to have the labels of a bar chart show other data than the data used to build the chart.

    I have 15 "steps" on the horizontal axis. The data used is a number, so for example the first bar (A) has a value of 5 so this would be a bar 1/3 full. I cannot change the data used.

    1) Looking to change the labels of the horizontal axis from the numbers 1-15 to something else, for example "name1-name15".

    2) Looking to change the data labels inside the bar chart to yet another data set that has dates. For example the first bar (A) has an attached date of 30/jun, so I would like to show 30/jun inside the bar chart as a data label.

    Are these possible? I may be using the wrong chart/graph/tool to show what I want to show, if so please tell me where to look.

    Thanks a lot!
    Attached Files Attached Files
    Last edited by TtNl; 08-31-2022 at 05:32 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. changing axis in line graph - label axis should be on y-axis
    By Falimus in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2020, 04:56 PM
  2. Data with the same horizontal axis label not autosumming in a pie chart
    By eckliptik in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-16-2014, 06:04 AM
  3. change to chart primary horizontal axis label or name
    By pwynkoop in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 04-10-2013, 01:30 AM
  4. Changing the label on the Horizontal Axis
    By vkartikv in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-25-2013, 05:04 AM
  5. [SOLVED] how to set horizontal axis label
    By Orongo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2013, 03:38 PM
  6. Replies: 1
    Last Post: 09-02-2011, 08:57 AM
  7. Label horizontal axis
    By seo1 in forum Excel General
    Replies: 4
    Last Post: 12-22-2010, 01:04 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