Help...Adding a trend line in a chart.

[Dinesh_Excel]

Hi Friends,

Need your help for adding a trend line marked in "Red" as Target line and "Amber" for the actual(% of OA total) from the below table.

Appreciate any help from your side on the below.
Attached sheet for your reference.

Thank you.

 

[Schu]

Hi Friends,

Need your help for adding a trend line marked in "Red" as Target line and "Amber" for the actual(% of OA total) from the below table.

Appreciate any help from your side on the below.
Attached sheet for your reference.

Thank you.




View attachment 27236


View attachment 27237

The trend lines you made should be on a secondary axis for it to appear. Right click on the line itself and select Format Data Series and select secondary axis. For newer versions of Excel (2010 i think) you can right click on the chart and select Change Chart Type, select combo and configure individual elements in your chart. Configure the right axis to a max of 100%. Hope this is what you wanted.

 

[Schu]

The trend lines you made should be on a secondary axis for it to appear. Right click on the line itself and select Format Data Series and select secondary axis. For newer versions of Excel (2010 i think) you can right click on the chart and select Change Chart Type, select combo and configure individual elements in your chart. Configure the right axis to a max of 100%. Hope this is what you wanted.

 

[Dinesh_Excel]

Thanks Friend..it helped me a lot.

I am trying to make an interactive chart as below.
keeping tower as dynamic range.

Have tried the below but am not able to connect to the base data.
Would be very thankful if you can assist me.

Attached sheet for your reference which includes base for other towers.

 

[Schu]

Thanks Friend..it helped me a lot.

I am trying to make an interactive chart as below.
keeping tower as dynamic range.

Have tried the below but am not able to connect to the base data.
Would be very thankful if you can assist me.

Attached sheet for your reference which includes base for other towers.

View attachment 27242

Dinesh_Excel,

Have you tried pivoting your table1, add slicers then build another table2 with references to the pivotdata in table2. Use this table2 to build your chart. Also, rename your columns with different names, you have 2 towers. Using your validation list means using vlookup to populate table2 and build your chart, which also works but slicers are the easiest for this.

 

[Schu]

Dinesh
Here it is. Using pivot and slicer. Have fun!

 

[Dinesh_Excel]

Thanks Schu...I tried this option too but somehow the requirement was not agreed by my Client.They had some requirement which should be in the lines as was requested earlier.

Appreciate if you can guide me as below snap.

 

[Schu]

Dinesh,




This is an entirely different thing from the first post. Start a new thread so this new question doesn't get buried under the first. Anyway, here is your chart.
Offset is used to find your selection in combo box, vlookup does the rest.

 

[Schu]

here's the file.

 

[Dinesh_Excel]

Thanks Schu..it completes my requirement.

Appreciate your help