• 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 -how to Create simple line view(desktop ver)

Y

Yodash28

New Member
Hello. Im trying to draw the most simplest line chart from table...to a value changes on a line chart
Col_time-ו select as axis-X
Flag_1- I select as values
I set Flag_1 as "dont summerise"...still...on selection i get "count of flag_1" ...and the values on the chart do not show the actual changes of Flag_1. so simple graph...but not good :(...any ideas?
Btw- i know its not bi with fact/dimentions...still..so simple..how do i get it?
 
Yodash28
As You've just read Forum Rules ...

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
How to get the Best Results at Chandoo.org
  • When drafting a question, try and lay out the question in a clear and concise way.
  • Try and tell the readers what is the situation, what have you tried and what do you want to achieve.
  • For the best/fastest results, Upload a Sample File...
 
vletm said:
Yodash28
As You've just read Forum Rules ...

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
How to get the Best Results at Chandoo.org
  • When drafting a question, try and lay out the question in a clear and concise way.
  • Try and tell the readers what is the situation, what have you tried and what do you want to achieve.
  • For the best/fastest results, Upload a Sample File...
Click to expand...
Hello, i attached a csv.
i create a line chart:
time - is the Axis
flag_A,flag_b - are Values

my target: for each Flag - to see a line chart that reflects its changes on time ( Axis)
how do i do it?
I configured in 'Column Tools' tab - the fields to be "Don't summerize"...but its not working...data presented is not good (i see on graph line is on value Y=1 although in CSV value is 0 )
any ideas how to get a simple line chart that reflects the data in the attached csv?
Thanks, yodash
 

Attachments

  • data_f.csv
    171 bytes · Views: 1
Yodash28
Please reread my #2 reply.
I named three points for You.
If You cannot upload an Excel-file, then how someone else could guess - what do You have there?
... eg are those Your flags there as texts (which looks like numbers)?
Ps. I don't use Power PI, but it could work as with normal chart ...
 
thanks, my solution i look for is in power bi, and i think i got one... i will take your points when opening my next issue' Thanks!
 
You must log in or register to reply here.
Back
Top