If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format Axis
I have a line chart which is pulling data from a different
sheet in my workbook. The X axis is the date, formatted: Jan-XX, Feb-XX, etc. The Y axis is dollar amounts formatted as 200000, 400000, etc. - increasing by 200K at each interval. - this is correct. The X axis is defaulting to date the same date all the way across, "Jan-00, Jan-00, Jan-00". So, I'm seeing Jan-00 12 times, where I would like to see each month of the year. When I change the X axis to so that it reads each month, as I'd like... The scale on my Y axis changes to: min = 0 (this is correct) max = 1 (not correct) Major Unit = .1 (not correct) Minor Unit = .002 (not correct) The desired values a min = 0 max = 1600000 major = 200000 minor = 40000 When I change the y axis to my desired values, my x axis (the months) remain correct, but I LOSE my data lines. Please help. Any suggestions would be extremely helpful. Thank you. |
Thread Tools | |
Display Modes | |
|
|