![]() if I right click on the graph I do not get "tools" and hence i can not get at formating for the axis as advised. My excel is office 365 and so is up todate. I looked on the web for help, but most of the help referred to excel of an old year. Perhaps the graph does not know how to look at the data format and thus guesses the format and in so doing gives me some weird answer. ![]() Figure 6 - Uncheck Allow Editing Directly in Cells. From the Excel Options window, choose Advanced in the left pane and then uncheck ‘Allow editing directly in cells’. I know the dates are formatted in the spread sheet. To do so, follow these steps: In Excel, click on the File menu and then click on Options. I would get dates like 3 oct 54 which is totally incorrect. Looking carefully at the chart date data I observed the dates are not copied correctly. Instead the data ends up as one glob of data. If I choose a line chart the blood pressure shows up just as I had imagined it wouldīut If i choose a scatter chart, I would have expected the data to be plotted against the dates found in the pressure data may or may not exist for many of the dates. You can also use the All Charts tab in Recommended Charts to create a Pareto chart (click Insert > Recommended Charts > All Charts tab. ![]() The spread sheet also has a column of systolic blood pressures. Click Insert > Insert Statistic Chart, and then under Histogram, pick Pareto. In my spread sheet I have a column of dates formatted as dd-mmm-yy.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |