Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How many data series can i format
I have a chart of values over time. I have 5 data series taken from a data
table. The values come up in the chart OK but as I wanted to format the different data series for color and data point shape it only allows me to format 4 series. In fact when I right click the 5th data series the format window wont even come up as it did with the previous 4. Is the a built in default limit? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How many data series can i format
There is a limit but you're about 250 series shy of it. You can't double
click on the series? What kind of chart is it? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Derek" wrote in message ... I have a chart of values over time. I have 5 data series taken from a data table. The values come up in the chart OK but as I wanted to format the different data series for color and data point shape it only allows me to format 4 series. In fact when I right click the 5th data series the format window wont even come up as it did with the previous 4. Is the a built in default limit? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How many data series can i format
Thanks for the interest Jon. Its a simple line chart of my electricity usage
with the virticle axis values 0-1000 and the bottom axis is time line Jan -Dec. I could include sending a copy of the worksheet if it would help. "Jon Peltier" wrote: There is a limit but you're about 250 series shy of it. You can't double click on the series? What kind of chart is it? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Derek" wrote in message ... I have a chart of values over time. I have 5 data series taken from a data table. The values come up in the chart OK but as I wanted to format the different data series for color and data point shape it only allows me to format 4 series. In fact when I right click the 5th data series the format window wont even come up as it did with the previous 4. Is the a built in default limit? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How many data series can i format
Derek/Jon,
I have a very similar problem which may help/hinder. I have a line chart which consists of 6 series. The sixth series and title of the chart is 'controlled' by a macro. The macro is in turn operated via a button. Each series consists of 4 values. When the macro is run, the sixth series loses the series name (=Sheet2!#REF!), and the last value ie the values decrease from Sheet2!$F$22:$F$25 to Sheet2!$F22:$F$24. Subsequently activiation of the macro decreases the values by 1 each time ( ie $23, $22, and so on until the values = Sheet2!#REF! Macro code parameter1 = "=" parameter2 = "BEBINGTON & WEST WIRRAL" parameter3 = "Coverage (less than 5 years since last adequate test) for the period 2001-2005. Target 80%" Call PCO(parameter1, parameter2, parameter3) the first two parameters amend autofilter parameters. the third amends the title of the chart Sub PCO(p1, p2, p3) Sheets("Sheet1").Select Selection.AutoFilter Selection.AutoFilter Sheets("Sheet1").Select Selection.AutoFilter Field:=1, Criteria1:=p1 Cells.Select Selection.Copy Sheets("Sheet2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Sheets("Sheet1").Select Selection.AutoFilter Selection.AutoFilter Selection.AutoFilter Field:=3, Criteria1:=p2 Cells.Select Selection.Copy Sheets("Sheet2").Select Range("A22").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Rows("22:22").Select Selection.Delete Range("A1").Select Sheets("Chart1").Select Call charttitle(p3) End Sub Filters and copies values from 1 sheet to another from which the chart is produced. Row 22 is deleted because that contains the column titles - all the data is copied over correctly, but the chart is incorrect ??? Hope this helps. any suggestions Mike "Derek" wrote: Thanks for the interest Jon. Its a simple line chart of my electricity usage with the virticle axis values 0-1000 and the bottom axis is time line Jan -Dec. I could include sending a copy of the worksheet if it would help. "Jon Peltier" wrote: There is a limit but you're about 250 series shy of it. You can't double click on the series? What kind of chart is it? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Derek" wrote in message ... I have a chart of values over time. I have 5 data series taken from a data table. The values come up in the chart OK but as I wanted to format the different data series for color and data point shape it only allows me to format 4 series. In fact when I right click the 5th data series the format window wont even come up as it did with the previous 4. Is the a built in default limit? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How many data series can i format
Thanks Michael, Im sure it would help but what your saying is so far over my
head. I just want to right click, format my series data, and be done with it. I dont know why it wont and I dont think I should have to be that knowlegable to do it. But thanks again for your interest. Derek "Michael" wrote: Derek/Jon, I have a very similar problem which may help/hinder. I have a line chart which consists of 6 series. The sixth series and title of the chart is 'controlled' by a macro. The macro is in turn operated via a button. Each series consists of 4 values. When the macro is run, the sixth series loses the series name (=Sheet2!#REF!), and the last value ie the values decrease from Sheet2!$F$22:$F$25 to Sheet2!$F22:$F$24. Subsequently activiation of the macro decreases the values by 1 each time ( ie $23, $22, and so on until the values = Sheet2!#REF! Macro code parameter1 = "=" parameter2 = "BEBINGTON & WEST WIRRAL" parameter3 = "Coverage (less than 5 years since last adequate test) for the period 2001-2005. Target 80%" Call PCO(parameter1, parameter2, parameter3) the first two parameters amend autofilter parameters. the third amends the title of the chart Sub PCO(p1, p2, p3) Sheets("Sheet1").Select Selection.AutoFilter Selection.AutoFilter Sheets("Sheet1").Select Selection.AutoFilter Field:=1, Criteria1:=p1 Cells.Select Selection.Copy Sheets("Sheet2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Sheets("Sheet1").Select Selection.AutoFilter Selection.AutoFilter Selection.AutoFilter Field:=3, Criteria1:=p2 Cells.Select Selection.Copy Sheets("Sheet2").Select Range("A22").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Rows("22:22").Select Selection.Delete Range("A1").Select Sheets("Chart1").Select Call charttitle(p3) End Sub Filters and copies values from 1 sheet to another from which the chart is produced. Row 22 is deleted because that contains the column titles - all the data is copied over correctly, but the chart is incorrect ??? Hope this helps. any suggestions Mike "Derek" wrote: Thanks for the interest Jon. Its a simple line chart of my electricity usage with the virticle axis values 0-1000 and the bottom axis is time line Jan -Dec. I could include sending a copy of the worksheet if it would help. "Jon Peltier" wrote: There is a limit but you're about 250 series shy of it. You can't double click on the series? What kind of chart is it? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Derek" wrote in message ... I have a chart of values over time. I have 5 data series taken from a data table. The values come up in the chart OK but as I wanted to format the different data series for color and data point shape it only allows me to format 4 series. In fact when I right click the 5th data series the format window wont even come up as it did with the previous 4. Is the a built in default limit? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Charting Data Series vs. Data Points? | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Format Data Series Markers | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |