Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
break XY data to series
Hi
I have a problam creating an XY chart in excel 2007 for each point (x,y) is in a certain group and i want to create a chart that color each point according to it's group. I tried to put each group in a diffrent series, but I only managed to do so manually, since I have nearly a hundred groups it's not so practical. my data is somthing like: X Y G 1 1 1 2 1 1 3 2 2 4 1 2 5 19 3 and so on. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
break XY data to series
Here's how to break it up:
http://peltiertech.com/Excel/Charts/...nalChart1.html Put your G values into the header cells to the right of the G column, then use formulas that return the value in the Y column if the value in the G column matches the header (otherwise return #N/A). Plot the X values against all of the columns under the G values. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message oups.com... Hi I have a problam creating an XY chart in excel 2007 for each point (x,y) is in a certain group and i want to create a chart that color each point according to it's group. I tried to put each group in a diffrent series, but I only managed to do so manually, since I have nearly a hundred groups it's not so practical. my data is somthing like: X Y G 1 1 1 2 1 1 3 2 2 4 1 2 5 19 3 and so on. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to replace a series of characters by a page break? | Excel Discussion (Misc queries) | |||
2nd Axes - primary series data of only 1 series disappears! | Charts and Charting in Excel | |||
how do I plot a data series against two series | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
How can I "break" the bar in a graph if a series is off the chart | Charts and Charting in Excel |