How to make a simulated *smooth* graphic in Excel or Access

Posted on 2012-09-11
Last Modified: 2012-09-15
Hi guys,

I'm working on a new project for my company and I need to create simulated graphs which will be used to test and foreseen real data. The graphs should be smooth curves as shown in the attached image. I've tried using different methods to create bell and gaussian curves but nothing really convince me.

What I need is to be able to input 5 or 6 different points and the curve should be created having in mind that is should be smooth... not plotted as square lines. Is it possible?

My final goal is to have that in Access so I can input all data in a form, lick a button and have the plot printed but I guess I'll be able to do that once I have the formula I need in Excel.

Is it possible?

Thanks in advance!
Question by:Caracena
    LVL 18

    Expert Comment

    In Excel create a line chart.
    Click the line data series you want smoothly curved.
    Go to Format and click Selected Data Series and go to the Patterns tab.
    Select Smoothed line.
    LVL 24

    Accepted Solution

    Are we talking about finding the "best fit" curves and plotting them in Excel for Normal distributions of Standard and Log Normal?

    it is possible to plot quite good plots in excel (see attached Normal Distribution plot)
    LVL 6

    Author Closing Comment

    Perfect! Thanks for the combination of formulas ;)

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now