+ Reply to Thread
Results 1 to 2 of 2

Plot dates of campaigns on a line graph

  1. #1
    Registered User
    Join Date
    02-19-2015
    Location
    Newcastle, England
    MS-Off Ver
    2013
    Posts
    98

    Plot dates of campaigns on a line graph

    hi

    is there a way to label dates of campaigns on a trend graph?

    I have thought about doing it manually (using arrows in the examples) but wonder if there is an easier way of presenting the data? I have specific dates of when the campaign starts and ends but could translate that to week numbers for ease

    thanks for any help
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,814

    Re: Plot dates of campaigns on a line graph

    Simply add a data series for each "campaign". For example, for the "f" array, add a column where the cells corresponding to labels 49 to 8 are blank, the cells corresponding to labels 9 to 12 contain 1120 (or whatever value you want), and the remaining cells in that column are also blank. Add that column as an additional data series, then format as desired (arrow and line color and all that).

    You might take note of this article (http://peltiertech.com/mind-the-gap-...g-empty-cells/ ) about how Excel treats blank cells in charts -- especially if you decide you want to use a formula to fill in these campaign columns, where you will need the NA() function instead of "blank".
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. plot line through graph minimums
    By sabriy in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-05-2016, 06:38 PM
  2. Macros to plot data in a line graph
    By taimysho0 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2014, 05:27 PM
  3. [SOLVED] How do you plot real time data into a line graph?
    By jonathan@ibbotsons in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-30-2013, 09:49 AM
  4. Line Graph - Do plot zero, Don't plot #NA
    By Janc in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-01-2012, 05:45 PM
  5. Replies: 1
    Last Post: 02-18-2012, 03:20 AM
  6. [SOLVED] how do I plot a constant value in a line graph?
    By Debby Blaine in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-11-2006, 04:15 AM
  7. [SOLVED] Scatter plot and line graph combination
    By Tim Gilderseeve in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-11-2005, 03:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1