If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
conditional formatting in charts
(a) What is the chart type? A stacked type may not show what you expect.
(b) What's the data look like? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Dan_Green" wrote in message ... 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 |
#3
|
|||
|
|||
conditional formatting in charts
Hi Jon,
The graph is a mixture of columns which show Sale, Target, each month along the x axis. In addition to this i have as lines culumative sales, and a 12 MAT line. Regarding the data: I've just the same data in different graphs that I havemade from Scratch and all target numbers show on the graph regardless of whether there are sales inthe same month, so I think I that the problem lies inthe formatiin of the graph. Could that be right ? Thanks again Daniel "Jon Peltier" wrote: (a) What is the chart type? A stacked type may not show what you expect. (b) What's the data look like? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Dan_Green" wrote in message ... 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting - Formulas | meandmyhorse | General Discussion | 2 | February 18th, 2006 12:58 PM |
Conditional Formatting in Access 2000 | Basingstoke | Using Forms | 1 | January 20th, 2006 04:41 PM |
Conditional Formatting when inserting a row | zahoulik | Worksheet Functions | 2 | January 7th, 2006 03:01 PM |
Conditional formatting : amount of decimals | belgian11 | General Discussion | 0 | December 25th, 2005 04:47 PM |
Conditional formatting in Charts? | Todd | Charts and Charting | 1 | January 11th, 2005 06:32 PM |