Solved

Excel Line chart

Posted on 2014-01-26
6
385 Views
Last Modified: 2014-02-12
Hi,
In Sheet4 I want to create line chart for each value I have in "ColumnB", there are about 9 values for each day and the chart suppose to show me the trend of each values in ColumnB.
0
Comment
Question by:motioneye
  • 3
  • 2
6 Comments
 
LVL 8

Expert Comment

by:itjockey
ID: 39811143
Hi motioneye,

Select All nine values  & Then
TAB - Insert - Select - Line Chart


Thanks
0
 

Author Comment

by:motioneye
ID: 39811161
Hi,
I need to know how to present all 9 values as a line chart in single chart presentation.
0
 
LVL 8

Expert Comment

by:itjockey
ID: 39811204
Select all 9 values & then proceed above. or pls attached your sample file.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:motioneye
ID: 39811216
here it comes, sorry I thought I already attached the file...
linechart.xlsx
0
 
LVL 34

Accepted Solution

by:
Dan Craciun earned 500 total points
ID: 39811371
Sort by table name, then create a line chart with series name as [dbo].[alert], series values the cells in column C corresponding to [dbo].[alert] (C2:C411) and axis label range A2:411.
This will add the first line to your chart.

After that press Add on your legend entries (Series) and repeat for the remaining values.
Chart with the first 3 series attached.

HTH,
Dan
linechart-mod.xlsx
0
 

Author Closing Comment

by:motioneye
ID: 39854926
This is excellent help
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
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.

707 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

18 Experts available now in Live!

Get 1:1 Help Now