+ Reply to Thread
Results 1 to 2 of 2

I want to draw a line through the columns of a chart, plot the o.

  1. #1
    Dewey
    Guest

    I want to draw a line through the columns of a chart, plot the o.

    I have a basic column chart showing regional sales results by month. I would
    like to draw a line through the columns. The line represents the overall
    (all regions combined) sales results. The line needs to have a point for
    each month that represents the sales number.

  2. #2
    Jon Peltier
    Guest

    Re: I want to draw a line through the columns of a chart, plot theo.

    Dewey -

    Make your column chart with one extra series, which contains the overall
    results. Select this overall series, choose Chart Type from the Chart
    menu, and select a suitable Line style.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______

    Dewey wrote:

    > I have a basic column chart showing regional sales results by month. I would
    > like to draw a line through the columns. The line represents the overall
    > (all regions combined) sales results. The line needs to have a point for
    > each month that represents the sales number.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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