Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi, this is my first time posting. I need to create a graph of two variables,
but I have way to many data points (over 32,000) If I wanted to select say every 5 data points and then use these to make a graph, how would I do this? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
If your data are in columns A and B, in C1 enter =mod(row(),5) and copy
this formula down. then filter the colomns A B and C to keep only lines with 0 in column C Only one data out of 5 will appear in your graph (which is still quite a lot !) Misange Jaylynn a écrit : Hi, this is my first time posting. I need to create a graph of two variables, but I have way to many data points (over 32,000) If I wanted to select say every 5 data points and then use these to make a graph, how would I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Labels- POssible to show data value and data label together? | Charts and Charting in Excel | |||
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) |