![]() ![]() Then change the alignment axis options to Rotate all text 270 degrees. To do this, double click on the horizontal axis time numbers. First, we need to make it so that we can see the horizontal axis values as they are overlapping each other. Now there is a few things we need to fix in order to get the final Excel chart. If you pick that chart type, Excel will create your desired chart in a step format like you see here:ĥ) Change Horizontal Axis Alignment to Vertical ![]() In order for Excel to treat our data correctly, we need to pick an XY Scatter with Straight Lines: ![]() Here is what it looks like if we chart the data as a line chart: So we need to pick a different type chart. Normally, we can just use a line chart, but Excel doesn’t plot time data the same that it does with dates. Here is where we need to adjust our step chart to use a different chart type. Now that we have our data setup, we can create our chart. What this does is copy the chart y axis position data for the matching time and then duplicates each value one time for the next horizontal point.Ĥ) Create XY Scatter Line Chart from Chart Data ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |