| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
x axis not showing correct values
i have dates on my x axis, but for this graph i am not using all of it, e.g.
it goes from monday to sunday but im only using monday to wednesday and friday to sunday, but it is showing the whole lot rather than what i have input. =('Rel. PE in progress'!$C$2:$CT$2,'Rel. PE in progress'!$DG$2:$DR$2) i am using this same formula for the values on the graph and they are showing up correctly. not sure why the difference thanks anyone |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
| How do I eliminate duplicate values on y axis of an Excel chart? | Charts and Charting in Excel | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Graphing Reversing the Axis | Setting up and Configuration of Excel | |||
| Spreadsheet is only showing formulas not the actual values | Excel Worksheet Functions | |||
Threaded Mode
