Jump to content

 

Photo

How to set Multiple Row Labels as in Excel


  • Please log in to reply
4 replies to this topic

#1 anushhprabu

anushhprabu

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 29 February 2012 - 09:20 AM

Hi,
I have data points in which i have to show the chart with more than one data point in X-Axis.
like Month and Weeks and then the Y Axis with counts..
Below are my data points and i have attached sample chart with this for your reference.,. i'm new to Visifire (just bought 10 days back). Can you please help me in knowing how this can be configured in Visifire?

Month Week Type Count
Jan W1 S1 30
Jan W1 S2 20
Jan W1 S3 40
Jan W1 S4 24
Jan W1 S5 25
Jan W1 S6 35
Jan W2 S1 20
Jan W2 S2 30
Jan W2 S3 40
Jan W2 S4 50
Jan W2 S5 25
Jan W2 S6 20
Jan W3 S1 40
Jan W3 S2 20
Jan W3 S3 30
Jan W3 S4 35
Jan W3 S5 25
Jan W3 S6 45
Jan W4 S1 40
Jan W4 S2 20
Jan W4 S3 30
Jan W4 S4 35
Jan W4 S5 25
Jan W4 S6 45
Feb W1 S1 30
Feb W1 S2 20
Feb W1 S3 40
Feb W1 S4 24
Feb W1 S5 25
Feb W1 S6 35
Feb W2 S1 20
Feb W2 S2 30
Feb W2 S3 40
Feb W2 S4 50
Feb W2 S5 25
Feb W2 S6 20
Feb W3 S1 40
Feb W3 S2 20
Feb W3 S3 30
Feb W3 S4 35
Feb W3 S5 25
Feb W3 S6 45
Feb W4 S1 40
Feb W4 S2 20
Feb W4 S3 30
Feb W4 S4 35
Feb W4 S5 25
Feb W4 S6 45
Mar W1 S1 50
Mar W1 S2 20
Mar W1 S3 30
Mar W1 S4 24
Mar W1 S5 10
Mar W1 S6 35
Mar W2 S1 20
Mar W2 S2 30
Mar W2 S3 5
Mar W2 S4 50
Mar W2 S5 25
Mar W2 S6 50
Mar W3 S1 10
Mar W3 S2 20
Mar W3 S3 30
Mar W3 S4 35
Mar W3 S5 25
Mar W3 S6 45
Mar W4 S1 40
Mar W4 S2 2
Mar W4 S3 30
Mar W4 S4 15
Mar W4 S5 50
Mar W4 S6 10
Attached File  Sample Chart.png   15.17K   7 downloads

#2 sharmila

sharmila

    Advanced Member

  • Administrators
  • PipPipPip
  • 697 posts
  • Gender:Female

Posted 29 February 2012 - 10:14 AM

Hi anushhprabu,

You can create the above chart by using CustomAxisLabels in x-axis. Please check out the links given below.

http://www.visifire....omAxisLabel.htm
http://www.visifire....=600&height=375

Regards,
Sharmila

#3 anushhprabu

anushhprabu

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 29 February 2012 - 11:22 AM

Hi anushhprabu,

You can create the above chart by using CustomAxisLabels in x-axis. Please check out the links given below.

http://www.visifire....omAxisLabel.htm
http://www.visifire....=600&height=375

Regards,
Sharmila


Sharmila, Thanks for quick response. :)

#4 anushhprabu

anushhprabu

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 29 February 2012 - 12:15 PM

Sharmila, Thanks for quick response. :)

Hi Sharmila,

Thanks for sharing the details. I need to produce stacked column chart as mentioned in my previous attached image, i tried to convert your code to stacked, but its not working.

Can u pls help me to solve my problem?

Thanks in Advance.

#5 shoaib

shoaib

    Advanced Member

  • Members
  • PipPipPip
  • 924 posts
  • Gender:Male
  • Location:Bangalore

Posted 29 February 2012 - 12:43 PM

Hi Anushhprabu,

You can refer to similar post here on how to create StackedColumn chart.

Regards,
Shoaib




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users