+ Reply to Thread
Results 1 to 2 of 2

3D Surface Chart: Axis Labeling Discrepancy

  1. #1
    Registered User
    Join Date
    01-27-2023
    Location
    Chicago, Illinois
    MS-Off Ver
    2212
    Posts
    1

    Question 3D Surface Chart: Axis Labeling Discrepancy

    I have two worksheets, one from around a year ago (TemperatureDataFinal.xlsm) and one that I am making right now (thermal-clean.xlsx). They are both basically the same. I have an array of data with the following format: some columns of data, with a column of numbers that I want as my Y-axis, and a row of numbers I want as my X-axis. In my worksheet from a year ago I have a surface chart with the data values as the Z-axis and the X and Y-axes as intended. However, in my new worksheet I cannot manage to get the Y-axis to display as anything other than 'Series X' on the chart. How can I fix this without manually setting the Series names one-by-one, which I know I didn't do last time?

    More context:
    The column of numbers I want as Y-axis is timestamps. So my first chart's Y-axis displays as "0.00, 1.63, 3.49, 4.99, 6.52" from front to back. My new chart displays as "Series 1, Series 2, Series 3, Series 4, Series 5" from front to back.
    I'm setting the chart data identically. In the 'Select Data' window, I set the chart data as ='worksheet'!$C$2:$Z$2. I set the horizontal axis as ='worksheet'!$D$1:$Z$1, which works perfectly on both.
    I do have a couple of scripts on the older worksheet, the exact functionality of some I don't remember but I don't think it had anything to do with setting these axis labels.
    Attached Files Attached Files

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

    Re: 3D Surface Chart: Axis Labeling Discrepancy

    Use the select data dialog to redefine the range to use as data to

    ='thermal-clean'!$C$1:$Z$35
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. Excel Chart with Distance and Labeling on X Axis
    By jsimpson746 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-01-2014, 10:02 PM
  2. [SOLVED] Surface Chart Depth Axis showing all Data Series' on top of each other (Excel 2007)
    By enginezzz in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-26-2013, 11:22 AM
  3. Axis Graph Labeling
    By EAGLEBUCKS in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-15-2011, 03:31 AM
  4. [SOLVED] How to select numeric 'series axis' in a surface chart?
    By S.Grossmann in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-09-2006, 11:00 AM
  5. X-axis labeling
    By [email protected] in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-30-2005, 08:35 PM
  6. [SOLVED] Problem w/Chart Axis labeling with VBA
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 07-19-2005, 05:05 PM
  7. How do I add y-axis labeling on the right side of chart?
    By DavidNHFCU in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-30-2005, 11:06 PM

Tags for this Thread

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