|
|||||||||||||||||||||
|
#1
|
|||
|
|||
|
Shifting x-values in chart
Hello, I have a line graph, and I am trying to shift it to the left by 5 units. For example, consider the following data set:
x: 5, 6, 7, 8, 9 y: 30, 54, 65, 79, 21 would become: x: 0, 1, 2, 3, 4 y: 30, 54, 65, 79, 21 I know I can do this by modifying the source data in the spreadsheet, but I'd rather do this in the options of the chart. For example, is it possible to use formulas in the "Source Data" dialog box to shift the x values to the left by 5? Thanks. |
|
#2
|
||||
|
||||
|
Not within the chart. Charts just plot the data provided.
The simplest thing would be to use another set of cells where you change the values via formula. Or if you don't want to use cells you could use a named formula. See attached. |
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Chart to ignore zero values - can it be done | nigelog | Excel Programming | 8 | 06-27-2008 11:18 AM |
| creating a percentage chart based on values | dan_77 | Excel Charting | 1 | 02-27-2008 10:28 PM |
| Adding % values to a bar chart | jghutch | Excel Charting | 1 | 02-09-2007 03:02 PM |
| Going insane! | kik | Excel - New Users | 10 | 01-31-2007 08:21 AM |
| values in a chart that shouldn't be there | brassmonkey | Excel Charting | 1 | 11-11-2006 08:50 PM |