Hello. I have expenses year over year in a chart and I want to compare to customer growth. I tried creating a secondary axis but it looks stupid because the line doesn't really line up with the column charts. Maybe I should just add text saying customer growth was x%. Any thoughts? Spreadsheet attached. Also, why do the dates show up as January when I have March in the cells?
How do you expect it should look like?Originally Posted by ammartino44
Strange. When I format text in table as number then it show proper date in the chart.
But not when I format it as date.
Foramt/Format Axis to Text axis gets the dates sorted. However, I'm not sure what you want about the secondary axis. Do you wan the line extended forward back (I did that with a trend line and it doesn't look good...). Or do you want it running through zero? Or something else?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Using a date axis set to use years as units, you get the first day of each year as labels. You don't really want a date axis anyway for just two dates.
Remember what the dormouse said
Feed your head
@ romperstomper. I don't follow you. What do you mean a date axis as units? I'm comparing volume from two months. Why wouldn't I want a date axis and why would it default to Jan when I clearly have Mar written as my column headers? If I don't have a date axis I can't show what periods I'm comparing.
Because in your original graph, you had the x-axis set to DATE not TEXT. That's the change that I made...
Hi Amma - kindly follow the forum rules as this is seems to be duplicate content post with thread " dates are off in excel column chart".
Please take care in future.
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
The chart axis is either a date axis or a category axis. If it is a date axis, it plots your data against the date values, leaving gaps for any missing dates, and it will use the first day of each unit period as the label. So if you have days as units, it will show you each day; if you use months, the label will use the first of each month; for years, it will use 1st Jan of each year. (typically, you would use a number format for the display based on the unit - eg mmm-yy for month, or just yyyy for year)
For your purposes here you do not need any of that functionality, so you should specify a text axis so that it simply plots each X axis value as the next category.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks