Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart formatting
Hi. I have a chart with 96 series, these series have around 76 data points
each and are expressed in a line chart. I would like to be able to automatically colour the lines for each series based upon the name of each series. The names of each series are identified by the header of the particular column/row. Is this possible? I have looked through other questions on here, but they dont seem to be relevant to this particular case. Thanks in advance. James |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart formatting
Seeing as Excel pre-2007 only has a 56 colour colour palette, how do you
distinguish between them? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Hi. I have a chart with 96 series, these series have around 76 data points each and are expressed in a line chart. I would like to be able to automatically colour the lines for each series based upon the name of each series. The names of each series are identified by the header of the particular column/row. Is this possible? I have looked through other questions on here, but they dont seem to be relevant to this particular case. Thanks in advance. James |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart formatting
Most would be in the same group, so the same colour. i.e. 10 of one 10 of
another etc. Anything not classed in a particular group would be classed in an unknown group, which would all be the same colour. Any sense to that? "Bob Phillips" wrote: Seeing as Excel pre-2007 only has a 56 colour colour palette, how do you distinguish between them? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Hi. I have a chart with 96 series, these series have around 76 data points each and are expressed in a line chart. I would like to be able to automatically colour the lines for each series based upon the name of each series. The names of each series are identified by the header of the particular column/row. Is this possible? I have looked through other questions on here, but they dont seem to be relevant to this particular case. Thanks in advance. James |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart formatting
Yeah, but I think you have to do it by VBA.
Here is a basic example that you can tweak Dim i As Long Dim arycolours arycolours = Array(36, 38, 53, 3, 5, 6, 10, 41, 56, 387, 22) With ActiveSheet.ChartObjects(1).Chart For i = 1 To 9 .SeriesCollection(i).Border.ColorIndex = arycolours(i - 1) Next i End With -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Most would be in the same group, so the same colour. i.e. 10 of one 10 of another etc. Anything not classed in a particular group would be classed in an unknown group, which would all be the same colour. Any sense to that? "Bob Phillips" wrote: Seeing as Excel pre-2007 only has a 56 colour colour palette, how do you distinguish between them? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Hi. I have a chart with 96 series, these series have around 76 data points each and are expressed in a line chart. I would like to be able to automatically colour the lines for each series based upon the name of each series. The names of each series are identified by the header of the particular column/row. Is this possible? I have looked through other questions on here, but they dont seem to be relevant to this particular case. Thanks in advance. James |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart formatting
Thanks Bob.
I have no experience with VBA, so wouldn't know where to start. Cheers, Jim "Bob Phillips" wrote: Yeah, but I think you have to do it by VBA. Here is a basic example that you can tweak Dim i As Long Dim arycolours arycolours = Array(36, 38, 53, 3, 5, 6, 10, 41, 56, 387, 22) With ActiveSheet.ChartObjects(1).Chart For i = 1 To 9 .SeriesCollection(i).Border.ColorIndex = arycolours(i - 1) Next i End With -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Most would be in the same group, so the same colour. i.e. 10 of one 10 of another etc. Anything not classed in a particular group would be classed in an unknown group, which would all be the same colour. Any sense to that? "Bob Phillips" wrote: Seeing as Excel pre-2007 only has a 56 colour colour palette, how do you distinguish between them? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Hi. I have a chart with 96 series, these series have around 76 data points each and are expressed in a line chart. I would like to be able to automatically colour the lines for each series based upon the name of each series. The names of each series are identified by the header of the particular column/row. Is this possible? I have looked through other questions on here, but they dont seem to be relevant to this particular case. Thanks in advance. James |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart formatting
Okay. Let's get a bit more detail.
You say you have 96 series, coloured in groups of 10. Are they structures, such that series 1-10 is one colour, 11-20 another and so on. What are the colours (preferably colorindex) per group? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Thanks Bob. I have no experience with VBA, so wouldn't know where to start. Cheers, Jim "Bob Phillips" wrote: Yeah, but I think you have to do it by VBA. Here is a basic example that you can tweak Dim i As Long Dim arycolours arycolours = Array(36, 38, 53, 3, 5, 6, 10, 41, 56, 387, 22) With ActiveSheet.ChartObjects(1).Chart For i = 1 To 9 .SeriesCollection(i).Border.ColorIndex = arycolours(i - 1) Next i End With -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Most would be in the same group, so the same colour. i.e. 10 of one 10 of another etc. Anything not classed in a particular group would be classed in an unknown group, which would all be the same colour. Any sense to that? "Bob Phillips" wrote: Seeing as Excel pre-2007 only has a 56 colour colour palette, how do you distinguish between them? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Hi. I have a chart with 96 series, these series have around 76 data points each and are expressed in a line chart. I would like to be able to automatically colour the lines for each series based upon the name of each series. The names of each series are identified by the header of the particular column/row. Is this possible? I have looked through other questions on here, but they dont seem to be relevant to this particular case. Thanks in advance. James |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart formatting
Hi again.
As an example there would be 10 of one condition (call them positive - Green) 10 of another (Negative - Red) and the 76 remaining would be unknowns which would be grouped in the same colour(Blue). Would it help to send the spreadsheet? Many thanks for your help, James "Bob Phillips" wrote: Okay. Let's get a bit more detail. You say you have 96 series, coloured in groups of 10. Are they structures, such that series 1-10 is one colour, 11-20 another and so on. What are the colours (preferably colorindex) per group? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Thanks Bob. I have no experience with VBA, so wouldn't know where to start. Cheers, Jim "Bob Phillips" wrote: Yeah, but I think you have to do it by VBA. Here is a basic example that you can tweak Dim i As Long Dim arycolours arycolours = Array(36, 38, 53, 3, 5, 6, 10, 41, 56, 387, 22) With ActiveSheet.ChartObjects(1).Chart For i = 1 To 9 .SeriesCollection(i).Border.ColorIndex = arycolours(i - 1) Next i End With -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Most would be in the same group, so the same colour. i.e. 10 of one 10 of another etc. Anything not classed in a particular group would be classed in an unknown group, which would all be the same colour. Any sense to that? "Bob Phillips" wrote: Seeing as Excel pre-2007 only has a 56 colour colour palette, how do you distinguish between them? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Hi. I have a chart with 96 series, these series have around 76 data points each and are expressed in a line chart. I would like to be able to automatically colour the lines for each series based upon the name of each series. The names of each series are identified by the header of the particular column/row. Is this possible? I have looked through other questions on here, but they dont seem to be relevant to this particular case. Thanks in advance. James |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart formatting
Yeah that would be best.
But also explain, what does unknown mean, they must be positive or negative. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Hi again. As an example there would be 10 of one condition (call them positive - Green) 10 of another (Negative - Red) and the 76 remaining would be unknowns which would be grouped in the same colour(Blue). Would it help to send the spreadsheet? Many thanks for your help, James "Bob Phillips" wrote: Okay. Let's get a bit more detail. You say you have 96 series, coloured in groups of 10. Are they structures, such that series 1-10 is one colour, 11-20 another and so on. What are the colours (preferably colorindex) per group? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Thanks Bob. I have no experience with VBA, so wouldn't know where to start. Cheers, Jim "Bob Phillips" wrote: Yeah, but I think you have to do it by VBA. Here is a basic example that you can tweak Dim i As Long Dim arycolours arycolours = Array(36, 38, 53, 3, 5, 6, 10, 41, 56, 387, 22) With ActiveSheet.ChartObjects(1).Chart For i = 1 To 9 .SeriesCollection(i).Border.ColorIndex = arycolours(i - 1) Next i End With -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Most would be in the same group, so the same colour. i.e. 10 of one 10 of another etc. Anything not classed in a particular group would be classed in an unknown group, which would all be the same colour. Any sense to that? "Bob Phillips" wrote: Seeing as Excel pre-2007 only has a 56 colour colour palette, how do you distinguish between them? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "r10jdl" wrote in message ... Hi. I have a chart with 96 series, these series have around 76 data points each and are expressed in a line chart. I would like to be able to automatically colour the lines for each series based upon the name of each series. The names of each series are identified by the header of the particular column/row. Is this possible? I have looked through other questions on here, but they dont seem to be relevant to this particular case. Thanks in advance. James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel |