- Messages
- 291
- Reaction score
- 1,576
- Points
- 153
Sorry to bother you, but i really don't know why when i opened your answers from the spreadsheet N/A signs appear in the J8BUS workbook and in the automatic calendar days workbook #VALUE! appear. I also don't really know how to do the graph. I actually tried doing that question and i did the same thing like you did which was finding the destination, then the number of trips and the average minutes it was late, but then when i had to make the graph i used a scatter graph and i don't know why my horizontal axis are not correct so instead of having (Dive centre, tawara town centre,..) it has numbers and i don't know what to do. I'll also upload my file so it could be easier to understand what i mean.
Thank you, i really appreciate your help.
1. The N/A sign appears for routes which have the no 8,and that is because in the {table array of lookup} J8SEATS,there is no value for 8.
even the ms shows N/A for no 8.
2.( in the automatic calendar days workbook #VALUE! appear.) where is this?? I didnt get this.
3.I dont know how to make the no into text on the horizintal axis,
but one thing which I noticed was that its we should select such a chart type which shows only "Series value" in 'edit data series' and does not show "Series X value" & "Series Y value", like line,bar,column,pie,etc. And we have been given a choice to select the chart type.
{see the attachment to understand better}
I tried with all the chart types and came on this conclusion.
Because such charts show the exact text of the data.
Hope you understand,
and sorry I couldn`t help you much this time.