How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I need help with creating and showing a secondary horizontal

Customer Question

I need help with creating and showing a secondary horizontal axis. I want to label a time on the lower axis and a date on the top axis. I have both these values in columns in the spreadsheet. Please help.
Submitted: 5 months ago.
Category: Microsoft Office
Expert:  Jess M. replied 5 months ago.

Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

What version of Excel are you using?

Can you send a sample or dummy Excel file with the chart and data for me to work on?
Please let me know by replying to me here so that I can help you further.

Best regards,

Customer: replied 5 months ago.
Jess, I send you the Excel spreadsheet in question. The chart is at the bottom of the data columns at approximately row 780. This is a chart of hourly temperature for one month. To review, my problem is that I am unable to post column J, a date, along the top of the chart. I want to post the date at increments of 24 data values (one day increments). I guess this would be called a secondary horizontal axis. The primary horizontal axis is at the bottom of the chart and is posting time of day of the temperature recording.You will observe that the chart is a "combo", posting the continuous temperature data in "line" type chart, and posting the other non-continuous data as "scatter" type.To me, this should be easy as it is common for scientific data display. If you can figure out how to make Excel do this, I hope you will demonstrate the method to me in an online session or otherwise explain it to me in an email. I will gladly pay the fee of $39 if you can achieve the chart display I require.I hope to hear from you soon. Good day, Monte Naylor
Customer: replied 5 months ago.
Jess, I am using Office 365 recently updated. Also, I attach a slightly simpler version of the spreadsheet "broomfield...". The chart of the first file I sent you used a sub-set of the entire data. To simplify the data selection, I removed the unused data that might have caused confusion for you.If you want to call me, my telephone number is(###) ###-####
Monte Naylor
Expert:  Jess M. replied 5 months ago.


Sorry for the late reply. Please give me a moment to check your requirements.


Expert:  Jess M. replied 5 months ago.

Hi, I am sorry but I am out of ideas. Please allow me to opt out so that other experts can help you further. You will be notified when other expert join you here.

Thank you.