|
|
|
|
#1
08-07-2023, 12:29 AM
|
|||
|
|||
You need all years the event was happening in source table!
An example how i'd do this is attached. Events are defined in table tEvents on Events sheet. The column EventVal is used to determine the position of event in graph, and must be an unique value for every event! On sheet SetUp you can determine the start year for table tEY on sheet EventYears. This table will be the source for your graph. You create a graph based on table tEY on sheet EventYears. Event labels for graph you get from named range nEvents at top of same sheet. 
|
|
#2
08-07-2023, 12:36 AM
|
||||
|
||||
|
Graph
Thank you SO MUCH for your help!
Being that I am an absolute DUMMMMMY in Excel could I trouble you to create the graph also? Hopefully I can finetune things from there. Thanks again Susan
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with plotting new chart after every data refresh | ebutu555 | Excel | 2 | 08-27-2017 11:37 PM |
| Historical Mark on Powerpoint Chart | ivanjay205 | PowerPoint | 0 | 12-11-2016 06:14 AM |
| How do I edit or delete calendar events via an Excel spreadheet? | kleetus51 | Outlook | 0 | 03-03-2014 04:07 PM |
| Why selecting two columns (x and y) for plotting produces two graphs? | Jamal NUMAN | Excel | 0 | 01-21-2012 12:42 AM |
| Plotting LARGE WALL CHARTS | Butch Jackman | Excel | 0 | 05-25-2006 07:06 AM |
Windows 8 
Office 2016
Hybrid Mode