Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
conditional formatting in charts
Hi,
I was given a workbook containing a chart from a collegue .I saved the format of this chart as a custom Chart format The Chart is used for measuring/showing monthly sales against budget, and also contain a MAT line. My question is : I have I have data in my Targets Column, with the range shown as follows =SERIES(Data!$X$2;Data!$A$75:$A$86;Data!$X$75:$X$8 6;2) But I only See this target data only when I the series for my Sales Data has the same rows. I.e If my sales series is as follows, can only see the data in X75 =SERIES(Data!$W$2;Data!$A$75:$A$86;Data!$W$75:$W$7 5;1) and likewise if My series is =SERIES(Data!$W$2;Data!$A$75:$A$86;Data!$W$75:$W$8 6;1) Can I see on my chart all target data in the RAnge X75:x86. It appears all other series's are dependent on whether there is a sales value in each month before other values ( i.e Targets) are shown Can someone help - I've looked in VB Editor, and cannot see any code relting to the graph, unless it is hidden. Thanks Rgds Daniel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional formatting backgrounds in charts | Charts and Charting in Excel | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
Conditional formatting in Charts? | Charts and Charting in Excel | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |