Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I customize the X-axis in excel to match my dataset?
I am trying to my x-axis to match my dataset. The axis is tied to a monthly
sampling event, however the events do not occur every 30 days. I want my first point to match the first sample date, and so-on. Thanks! |
#2
|
|||
|
|||
Cathy,
If I'm understanding correctly, you want to change the X-axis series from pointing at a data range that contains months to a data range that contains the dates that match your points. To do so, click once on your chart. In the standard toolbar, go to Chart - Source Data - Series Tab. At the bottom of the Source Data dialog box there is an input where you can change the X axis category range. ---- Regards, John Mansfield http://www.pdbook.com "cathy" wrote: I am trying to my x-axis to match my dataset. The axis is tied to a monthly sampling event, however the events do not occur every 30 days. I want my first point to match the first sample date, and so-on. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why can I not format a secondary axis in excel x? | Charts and Charting in Excel | |||
Excel graph y axis label cut | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
Y axis, need varying units | Charts and Charting in Excel |