• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Line chart

tomas

Active Member
Hi I would like to enhance my chart. In attachement there is a comment with instructions. Anyway I dont know if you can add series to the pivot chart out of pivot table. If not there is still dataset - one column a chart doesnt have to be pivot.

Thanks for looking at it
 

Attachments

  • chart.xlsx
    687.5 KB · Views: 0
Hi tomas,

I wasn't sure what you meant about the coloring, but I think this gets pretty close.
upload_2015-8-5_9-35-53.png
 

Attachments

  • chart LM.xlsx
    693.3 KB · Views: 0
Hats down !!! thank you

What I meant by this color is something like now in the attachment . But it's not so much important.

Can you please tell me how did you get vertical line in chart? I understand the formula but when I wanted to add new chart series into pivot chart it was grayed out.
 

Attachments

  • chart.png
    chart.png
    8.9 KB · Views: 1
Hats down !!! thank you

What I meant by this color is something like now in the attachment . But it's not so much important.

Can you please tell me how did you get vertical line in chart? I understand the formula but when I wanted to add new chart series into pivot chart it was grayed out.

Yes now I see it's not a pivot chart of course
 
Back
Top